Sales invoice have zero value (extended cost = 0)

(0) Share

Report

Posted on by Braw Rajab

hello,

i was reconciling my inventory to my GL and i fount out there are some invoices that does not match to any record on the GL level i searched for the document number in ( smartlist -> inventory -> inventory transactions) and saw one of them is a sales invoice and the extended price is 0 this is how it looks:

5824.Capture.PNG

and i went to the sales transaction window and this is what it looks like

3276.aa.PNG

my question is what is the issue here what could cause this problem and why there is no reference for this transaction on the GL level, because the are many other transactions with the same problem

Categories:

Microsoft Dynamics GP

All responses (7)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: Sales invoice have zero value (extended cost = 0)

I would agree that that is a disconnect occurring here. Do you have access to SSMS? You need to examine records in the IV10200,SOP30300 and GL20000 tables. The SOP screenshots all appear to be correct. It is the inventory transactions that appear to be wrong which in turn created no records in the GL20000 table. Do you have a test company? Item Type is Cards->Inventory->Item pull up the item and on the left-hand side of the screen is Item Type.
Braw Rajab 25 on at

Like (0)

Report

RE: Sales invoice have zero value (extended cost = 0)

the posting date is 9/1/2020
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Sales invoice have zero value (extended cost = 0)

If you click on the blue arrow next to date what is the posting date?
Braw Rajab 25 on at

Like (0)

Report

RE: Sales invoice have zero value (extended cost = 0)

here is the screenshot and what do you mean by what is the item type?
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Sales invoice have zero value (extended cost = 0)

OK, let's try a screenshot of GoTo - Distributions. What is the item type for this part?
Braw Rajab 25 on at

Like (0)

Report

RE: Sales invoice have zero value (extended cost = 0)

here you go sorry i didn't upload it like that i forgot

thank you
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: Sales invoice have zero value (extended cost = 0)

Please click the multi-line display icon(upper right-hand corner of grid) and send screenshot. The inventory transaction is indicating that this was a return.