Purchase Receipt Landed Cost issue - no vendor id, index, invoice match is zero.

(0) Share

Report

Posted on by Robyn

1,745

I have a purchase receipt with landed costs that has issues. Two of the three landed costs on it are fine, but one is troublesome. The landed cost record does not exist in the POP10500 table. In the POP30700 table, it has the following issues:

- Vendor ID is missing completely.

- Related to that, Vendor Note Index and purpvidx are not populated.

- Invoice_match is set to 0.

I can easily correct the fields in the POP30700, but recreating the POP10500 record is more problematic.

It looks like the landed cost amount is correct. My only outstanding issue is that I cannot Enter/Match the invoice for the landed cost because that receipt does not show up for that vendor.

What is the best way to fix?

How could this have happened? Other receipts for this kind of landed cost are just fine. How could it get written to POP30700 incorrectly and be completely missing from POP10500?

Thanks in advance.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Sherry Whitten 325 on at

Like (0)

Report

RE: Purchase Receipt Landed Cost issue - no vendor id, index, invoice match is zero.

Resolved. The user initially set up the landed cost ID without a vendor id. They entered and posted this receipt without a vendor ID. THEN they changed the landed cost ID to include a vendor id and check invoice match.

I assume the fix will be to just enter a vendor invoice for the landed cost that is not available to match, offsetting the accrued purchases account used on the receipt.