HISTORICAL STOCK STATUS REPORT IN GP

[swabunn]

Why historical stock status report showing sales transactions as positive numbers and receiving transactions as nagative numbers and calculating balance accordingly.

- s

 

[swabunn]

is it ok as far as sign are concerned.

I am using GL posting date option to print the report and I used march 31 as of date despite that in inventory report it is printing records relating to april.

-s

 

[Dukester0122]

since the report is giving you the inventory as-of, it's supposed to reverse the natural effect of the transaction to give you the on-hand on that date. Example below:

As-of 3/31/06 item ABC have 20. You sold 10 and received 5.

3/31/06 20
4/5/06 -10
4/20/06 5
Today 15

How Historical Stock Status report works:

As of Date: 3/31/06

Current Quantity: 15
4/20/06 -5
4/5/06 10
3/31/06 20

 

[swabunn]

is curent quantity a on hand quantity from the inventory inquiry window. is it taken from IV00102 table and as of transactions reversed are taken from iv30300.When I compare my crystal report with this report it gives me diffrence. I have made crystal report using IV00101, IV00102, IV30300, IV40202 tables and I have created view to pull GL posting date using IV30200, BM30200, SOP30200 and POP30300 tables

-swabunn

 

[UserofGP]

can you post your view or query here and maybe we can look the issue.

 

[swabunn]

Crystal Report: 9.0
Server: SQL Server
Great Plains: 8.0

Thanks for your reply.I have used the following view INVGLPSTDT to pull GLPOSTDT. I am also using other tables IV00101, IV00102, IV30300 & IV40202 for this report.

CREATE VIEW INVGLPSTDT
AS
select iv30200.trxsorce AS TRXSOURCE, iv30200.docnumbr AS DOCNUMBER,
IV30200.DOCDATE AS DOCDATE, IV30200.GLPOSTDT AS GLPOSTINGDATE from IV30200
UNION ALL
SELECT BM30200.TRXSORCE AS TRXSOURCE,BM30200.TRX_ID AS DOCNUMBER,
BM30200.TRXDATE AS DOCDATE, BM30200.PSTGDATE AS GLPOSTINGDATE FROM BM30200
UNION ALL
SELECT SOP30200.TRXSORCE AS TRXSOURCE, SOP30200.SOPNUMBE AS DOCNUMBER,
SOP30200.DOCDATE AS DOCDATE,SOP30200.GLPOSTDT AS GLPOSTINGDATE FROM SOP30200
UNION ALL
SELECT POP30300.TRXSORCE AS TRXSOURCE, POP30300.POPRCTNM AS DOCNUMBER,
POP30300.RECEIPTDATE AS DOCDATE, POP30300.GLPOSTDT AS GLPOSTINGDATE FROM POP30300

My record selection is as below:

{?Location} in [{IV30300.TRXLOCTN},{IV30300.TRNSTLOC}] and
{INVGLPSTDT.GLPOSTINGDATE} <= {?END DATE } and
{IV00101.ITEMTYPE} in 1 to 3

And two parameters (?EndDate) and {?Location}

The report is grouped by IV30300.Itemnmbr

I am using two formula to pull trxqty and exdcost in the report:

@trxqty :
if {IV30300.DOCTYPE} =3 and {IV30300.TRXLOCTN} = {?Location} and {IV30300.TRFQTYTY} = 1
then -({IV30300.TRXQTY} * {IV30300.QTYBSUOM})
else {IV30300.TRXQTY} * {IV30300.QTYBSUOM}

@exdqty

if {@trxqty} > 0 then {IV30300.EXTDCOST}
else if {@trxqty} < 0 then {IV30300.EXTDCOST}* -1
else 0


-swabunn

 

[UserofGP]

You do not have a date criteria applying to sales documents which is why you are seeing them.

 

[swabunn]

is sop30200.GLPOSTDT not pulling sales transactions by date
in the above view.Sorry I could not understand your question.

-swabunn

 

[swabunn]

historical stock status report is valuing items at origical cost of the transactions rather than at corrected unit cost adjusted through adjust cost utility. for example, the transaction was wrongly uploaded at unit cost 1436.88 for 12600 units and we adjusted the cost to .11 cents through adjust cost utility. Now historical cost is item at 1436.88, not at .11 cents.

Is there a way to correct report

Thanks

-Swabunn