Unable to batch create receipt that contains payment for purchase invoices

1

When I receive payments from Amazon, it contain both payment for purchase orders and deductions for advertising costs. The advertising costs are tied to a purchase invoice in Manager. I can created a receipt containing both AR and AP that are tied to invoices via the user interface, I do this so that I know which orders have been paid to me and how much advertising costs are still outstanding.

receipt_both_ar_ap
receipt_both_ar_ap796×301 8.99 KB

However, if I try to do this via Batch Create, then the payment received for AR will fail to map to an invoice. The payment for advertising does map to purchase invoices.

batch_result
batch_result1537×139 12.5 KB

Question: is there a limitation to doing this via batch upload or did I do something wrong?

The batch upload is shown below in row format for easy reading.

Date	9/16/2024
Reference	
PaidBy	Customer
Customer	DS001
Supplier	
Contact	
ReceivedIn	10001.002
Cleared	OnTheSameDate
BankClearDate	
ExchangeRate	
ExchangeRateIsInverse	FALSE
Description	
Lines.1.Item	
Lines.1.Account	d1489e95-bb28-4f5d-b42e-67d3291b3893
Lines.1.InterAccountTransferAccount	
Lines.1.AccountsReceivableCustomer	
Lines.1.AccountsReceivableSalesInvoice	GHrRPMsCK
Lines.1.BillableExpenseCustomer	
Lines.1.BillableExpenseSalesInvoice	
Lines.1.AccountsPayableSupplier	
Lines.1.PurchaseInvoice	
Lines.1.WithholdingTaxPayableSupplier	
Lines.1.Employee	
Lines.1.CapitalAccount	
Lines.1.SubAccount	
Lines.1.SpecialAccount	
Lines.1.FixedAsset	
Lines.1.IntangibleAsset	
Lines.1.ExpenseClaimsPayer	
Lines.1.Investment	
Lines.1.LineDescription	
Lines.1.Qty	
Lines.1.SalesUnitPrice	
Lines.1.Amount	10
Lines.1.DiscountPercentage	
Lines.1.DiscountAmount	
Lines.1.TaxCode	
Lines.1.CurrencyAmount	
Lines.1.Project	
Lines.1.Division	
Lines.2.Item	
Lines.2.Account	dac7ba37-0ccd-45e5-906e-548e6c50df37
Lines.2.InterAccountTransferAccount	
Lines.2.AccountsReceivableCustomer	
Lines.2.AccountsReceivableSalesInvoice	
Lines.2.BillableExpenseCustomer	
Lines.2.BillableExpenseSalesInvoice	
Lines.2.AccountsPayableSupplier	SP00001
Lines.2.PurchaseInvoice	2900-843850045
Lines.2.WithholdingTaxPayableSupplier	
Lines.2.Employee	
Lines.2.CapitalAccount	
Lines.2.SubAccount	
Lines.2.SpecialAccount	
Lines.2.FixedAsset	
Lines.2.IntangibleAsset	
Lines.2.ExpenseClaimsPayer	
Lines.2.Investment	
Lines.2.LineDescription	
Lines.2.Qty	
Lines.2.SalesUnitPrice	
Lines.2.Amount	-10
Lines.2.DiscountPercentage	
Lines.2.DiscountAmount	
Lines.2.TaxCode	
Lines.2.CurrencyAmount	
Lines.2.Project	
Lines.2.Division	
InventoryLocation	
HasLineNumber	FALSE
HasLineDescription	FALSE
QuantityColumn	FALSE
UnitPriceColumn	FALSE
Discount	FALSE
DiscountType	Percentage
AmountsAreTaxExclusive	FALSE
FixedTotal	FALSE
FixedTotalAmount	
CustomTheme	FALSE
ReceiptCustomTheme	
AutomaticReference	FALSE
HasReceiptCustomTitle	FALSE
ReceiptCustomTitle	
ShowTaxAmountColumn	FALSE
HasReceiptFooters	FALSE
2

It looks like you are referring to the invoice by its Description field here:

In order for this to work, you will either have to use the Reference field or GUID.

For example, it appears that the reference for the invoice in question is DS001. In that case, the batch text excerpt should read as follows:

Lines.1.AccountsReceivableSalesInvoice	DS001
3

NVM I’m stupid, because the payment is 90 days later, I didn’t have the corresponding Sales Invoice during this test. That’s why it didn’t map.

4

Don’t beat yourself up. We’ve all been there :grin: