Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Ranger 5/2/2013 1:01:18 PM

cant return po remainder.


we sent a guy to stay in a hotel.  the bill was 199.36.  the po created was for 199.68.   so we got the invoice, received it at the actual price (199.36) and paid them.  now, our purchasing guy is trying to do a return on the 32 cents so it can be closed.

the problem is, that when we try to do the return, nothing shows up in the card (Return Transaction Entry) to do the return.   we should see the 32 cents in there, right?

 OH, one more thing....our purchasing guy likes to switch the amount and quantity fields, so the po line in question has a quantity of 199.68 and a cost of 1.0000.  not sure if this will make a difference though.  On the po itself, the REMSUBTO field shows a value of 0.32000.

postatus = 4, statgrp=1, potype=1


Version: GP 2010
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables