Main content par jaayein

Guides

Excel se Proaqsa ERP tak, ek weekend mein

Saat kadam, kisi salahkar ki zaroorat nahi. Bas tithi chunna hi thoda kathin hai.

Spreadsheet ke kaalam ERP ke record ban rahe hain

· 8 minute padhein · Lekhak Proaqsa ERP

Shuruaat se pehle dhyaan dein

Excel chhodna ek tithi par saaf badlaav (cut-over) hai, puraane data ka roopantaran nahi. Ek tarikh ke balance aage laaiye aur usi din se naye document bhariye; purana workbook sirf padhne layak sangrah ban jaata hai.

  • Mahine ki pehli tarikh lijiye, taaki vivaran aapas mein mel khaayein.
  • Pehle se baant lijiye ki kaun kya bharega: item (maalik), partner (accountant), opening stock (store).
  • Workbook mitaaiye nahi; ek hafte tak usi se tulna hogi.

Saat kadam

Kaam ka kram.

  1. 1. Badlaav ki tithi

    Mahine ka pehla din. Usse pehle ka koi bhi lenden document ke roop mein nahi bhara jaata.

  2. 2. Soochiyan saaf

    Item aur partner ke alag-alag code; dohraav hataiye; band ho chuke naamon par nishaan lagaiye.

  3. 3. Company banaiye

    Dekhiye: account kaise banayein.

  4. 4. Mool jaankari

    Base unit aur packaging ke saath item, graahak/supplier role ke saath partner, aur locations.

  5. 5. Opening balance

    Stock, partner, bank aur nakad ke liye dekhiye opening balance ki margdarshika.

  6. 6. Saath chalne wala hafta

    Har bikri, kharid aur receipt ERP mein post kariye; saatvein din dono ke jod milaaiye.

  7. 7. Excel ko vida

    Workbook ko read-only kar dijiye. Vishleshan karna ho to ERP se export kar lijiye.

Aksar hone wali bhoolein

  • Purana itihaas document bana kar bharna — sirf balance bhariye, pichhle varsh ke invoice nahi.
  • Poore mahine dono systems ko "live" rakhna — saath chalane ke liye ek hafta paryaapt hai.
  • Unit aur packaging ki setting taal dena — pehli kharid se pehle ise sahi kar lijiye.

Aarambh

Apni muft company abhi banaiye.

FAQ

Aksar puchhe jaane wale sawal

Kya item kisi file se import ho sakte hain?

Ji haan, agar aapke plan aur role mein yah suvidha ho to Items Import/Export sheet se spreadsheet ke zariye item, unke unit, daam aur opening stock samet, load kiye ja sakte hain. Graahak aur supplier partner form par apne opening balance ke saath jode jaate hain.

Opening balance galat bhar diya to kya karein?

Opening tithi par vivaran (narration) ke saath ek sudhaar wala journal voucher post kariye; pehli entry record mein jas ki tas rehti hai.