• Registered: 08/17/2013
  • Posts: 7

Topic: Items do not show up correctly on sales invoice

Hi,

I'm in the processing of changing the software my company is using. After importing all the data from old database to current one via phpmyadmin. I am able to select the items in "sales invoice" but when I click on add, instead of adding an extra line with the item i added w/ quantity and price etc, its just blank.

Any insight into this would be appreciated.

Thank you

  • Registered: 12/25/2007
  • Posts: 2,446

Re: Items do not show up correctly on sales invoice

We know nothing about how you have imported the data and from what software. Probably this is just import error.
Janusz

  • Registered: 08/17/2013
  • Posts: 7

Re: Items do not show up correctly on sales invoice

Hi I found my problem.

in X_item_codes; item_code and stock_id must BOTH be equal to stock_id in X_stock_master when is_foreign=0
item_code may be different from stock_id if is_foreign=1 AND there is already another item code with is_foreign=0 and item_Code=stock_id

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,090

Re: Items do not show up correctly on sales invoice

Thanks. Wiki-ed it.

apmuthu's Website