I'm having a problem with one vendor where it looks like the expected unit cost field in the POORDLIN_SQL table should be showing up on our PO's but last price paid from the POITMVND_SQL is showing up or at least that what the amnt unit price matches up with, it is very odd, there is a lot of ratio math going on since we are buying in lbs and selling in LF so I assume the number in POORDLIN is gotten to or at least placed there after some math is done by the system I just can not figure out why the wrong number is showing up on the PO when the right number is in the field in the table that corresponds to the field on the PO form.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
PO Problem:
- Thread starter smtoomey3
- Start date
Sean,
If you have a POITMVND_SQL record set up that corresponds to the item and vendor combination, and the from and to dates are still within the date range of the PO order line delivery date, the cost of this record takes precedence over the last cost in the IMINVLOC_SQL table and subsequently populates the POORDLIN_SQL accordingly.
Is this not consistent with what you are seeing?
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
If you have a POITMVND_SQL record set up that corresponds to the item and vendor combination, and the from and to dates are still within the date range of the PO order line delivery date, the cost of this record takes precedence over the last cost in the IMINVLOC_SQL table and subsequently populates the POORDLIN_SQL accordingly.
Is this not consistent with what you are seeing?
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
- Status
Similar threads
- Locked
- Question