Sell to / bill To customer No. on value entries

peter123

Hi

After upgrading from Nav ver 3.70 to ver 6.0 , the value in the ”source No.” field in the value entry table is now the customers “Bill to No.” instead as before the “Sell to No.” this make report 113 “Customer/Item Sales” useless for us.
Is there another report which shows sales per Sell to customer?

Another issue is when using return orders sometimes the “Sell to Cust No.” value is placed in the “Source No.” field on value entry but most of the times it’s the “Bill to” value, and I can’t figure out why
Any ideas?
BR

Peter

David_Singleton

This is one of those ongoing issues. The logic is that the Value entry relates to the Billing and the Item Ledger Entry relates to Selling. It went back and forth a bit through the versions of Navision. I have a number of clients where we have had to add a new field to use old reports.

peter123

Hi David

thanks for the reply,

looks like I have to add a new field just to support report 113

I still cant figure out why sometimes a credit memo posted from return order set the sell to customer no on the value entry, I've been debugging all day and still cant find the bug.

br

Peter

Reynold

We encountered this issue and it appears that this was already fixed:

The "Customer/Item Sales" report and the "Inventory - Customer Sales" report display the statistics based on the Bill-to customer no. instead of the Sell-to customer no. unexpectedly in Microsoft Dynamics NAV