Share
ReportWhen i am going to post in POP Invoice Entry ,getting this error please help me out in this issue.
*This post is locked for comments
You’re offline. This is a read only version of the page.
790
When i am going to post in POP Invoice Entry ,getting this error please help me out in this issue.
*This post is locked for comments
Hi,
Run this query against the POP10300 - that's the Purchase Receipts Work file header file. The line items should be present in the POP10310 table. Do you find the receipt there?
Kind regards,
Leslie
Hi Soma
Here is more explanation on issue,Shipments are booked and i am going to map the Invoices to the Shipment like:
Invoice Numberr =R11328 and first line item i am going to map the Shipment Number =R11322 with Shipment Reciept Line number =16384
as well as second Line item mapping to hipment Number =R11322 with Shipment Reciept Line number =32768
by multiple line item it is getting an error .If it single line item working fine .
Please let me know where i am doing wrong?
Yes Soma By Manually its working fine
I checked in Database the table number POP10500 ,in that Shipments are available
select * from POP10500 where POPRCTNM='R11322'
Can you please let me know where i am wrong .
Hi Soma
I checked that Option is Checked in,
Nizamudeen,
Did you ever look in the table to make sure the line item you are trying to match does indeed exist? If I'm reading this correctly, you are matching the invoice to shipment receipt R11322 for Sequence number 16384. I guess I would check the database to see if the error is correct. Meaning, that shipment receipt may not exist in the database. You keep showing us the XML statement, but I don't see where you have verified the data is in the database to begin with. Are you trying to match an invoice to something you've received previously?
Kind regards,
Leslie
Hi Nizam,
First try to manually create this receiving invoice in GP and also check the "Allow Receiving without Purchase order" option is marked in Purchase order setup window (Tools-->Setup-->Purchasing-->Purchase Order Setup).
Hope this helps!!!
Below is the XML serialized by Econnect , there are two line items.
this xml is then use this method CreateTransactionEntity to create Purchase Invoice.
<?xml version="1.0" encoding="UTF-8"?>
-<eConnect xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance">-
<POPEnterMatchInvoiceType><eConnectProcessInfo xsi:nil="true"/>
<taRequesterTrxDisabler_Items xsi:nil="true"/><taUpdateCreateItemRcd xsi:nil="true"/><taUpdateCreateVendorRcd xsi:nil="true"/><taCreateVendorAddress_Items xsi:nil="true"/>+<taPopRcptLineTaxInsert_Items>-------<taPopDistribution_Items xsi:nil="true"/><taAnalyticsDistribution_Items xsi:nil="true"/>-<taPopEnterMatchInvLine_Items>-<taPopEnterMatchInvLine>
<POPRCTNM>R11328</POPRCTNM>
<POPMtchShpRcpt>R11322</POPMtchShpRcpt>
<ShipRCPTLNNM>16384</ShipRCPTLNNM>
<QTYINVCD>4500</QTYINVCD><
ITEMNMBR>P10</ITEMNMBR>
<VENDORID>1300</VENDORID>
<UNITCOST>2.50000</UNITCOST>
<EXTDCOST>11250.00</EXTDCOST>
<Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable></taPopEnterMatchInvLine>-<taPopEnterMatchInvLine>
<POPRCTNM>R11328</POPRCTNM>
<POPMtchShpRcpt>R11322</POPMtchShpRcpt>
<ShipRCPTLNNM>32768</ShipRCPTLNNM>
<QTYINVCD>3000</QTYINVCD>
<ITEMNMBR>P10</ITEMNMBR>
<VENDORID>1300</VENDORID>
<UNITCOST>2.80000</UNITCOST>
<EXTDCOST>8400.00</EXTDCOST>
<Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
</taPopEnterMatchInvLine></taPopEnterMatchInvLine_Items><taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true"/>-<taPopEnterMatchInvHdr>
<POPRCTNM>R11328</POPRCTNM>
<VNDDOCNM>022715 </VNDDOCNM>
<receiptdate>02/27/2015</receiptdate>
<BACHNUMB>INV-20150306 </BACHNUMB>
<VENDORID>1300</VENDORID>
<SUBTOTAL>19650.00</SUBTOTAL>
<TAXAMNT>1845.34</TAXAMNT>
<TAXSCHID>USASTCITY-6* </TAXSCHID>
<USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
</taPopEnterMatchInvHdr><taMdaUpdate_Items xsi:nil="true"/></POPEnterMatchInvoiceType></eConnect>
I would suggest try creating a sample record using GP and compare both the records in the SQL tables.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (