Posting payments REMADV

[Former Member]

I am attempting to post payments into SAP from a POS system. I am attempting to use REMADV with process code REMC. I believe this is a payment advice with clearning (which I believe posts payments to a customer account ??). Please advise if that is correct.

I am trying to effectively process a F-28 or FB05. I am new to accounting and cannot get the idoc to post....here is the data I am processing...

I am unable to get the idoc to post -- here are the key fields I am passing ->

I am unable to get REMC to post at all -- do you have a sample file or data you can share so I can see how to populate the idoc -- right now I have --

KU1-Document = REM

KU1-Reference number = REFNUM1

KU5-qualifier = '001'

KU5-amount = '52.00'

KU5-currency = 'USD'

B02-type = 'BA'

B02-BankID = '011000390' dummy bank

B02-country = 'US'

B02-accountnum ='12345678'

B02-Curr = 'US'

KA1-ParFun = 'AG'

KA1-Partner = '0000000001'

PU1-msg name = 'INV'

PU1-number = '9400000003'

PU5-qual = '001'

PU5-amount = '52.00'

K14-qual ='011'

K14-org = 'BP01'

I am trying to get the doc to post and get an error 'Company code could not be determined for intermediate document 0000000000007220' please help

Any help would be greatly appreciated -

Diana Greenberg

[Former Member]

I am attempting to post payments into SAP from a POS system. I am attempting to use REMADV with process code REMC. I believe this is a payment advice with clearning (which I believe posts payments to a customer account ??). Please advise if that is correct.

I am trying to effectively process a F-28 or FB05. I am new to accounting and cannot get the idoc to post....here is the data I am processing...

I am unable to get the idoc to post -- here are the key fields I am passing ->

I am unable to get REMC to post at all -- do you have a sample file or data you can share so I can see how to populate the idoc -- right now I have --

KU1-Document = REM

KU1-Reference number = REFNUM1

KU5-qualifier = '001'

KU5-amount = '52.00'

KU5-currency = 'USD'

B02-type = 'BA'

B02-BankID = '011000390' dummy bank

B02-country = 'US'

B02-accountnum ='12345678'

B02-Curr = 'US'

KA1-ParFun = 'AG'

KA1-Partner = '0000000001'

PU1-msg name = 'INV'

PU1-number = '9400000003'

PU5-qual = '001'

PU5-amount = '52.00'

K14-qual ='011'

K14-org = 'BP01'

I am trying to get the doc to post and get an error 'Company code could not be determined for intermediate document 0000000000007220' please help

Any help would be greatly appreciated -

Diana Greenberg

[Former Member]

I was able to figure out mapping on my own

KU1-Document = REM

KU1-Reference number = REFNUM1

KU1-Message type = 001

KU1-Confirm = 001

K03-Qual = '017'

K03-Date = any date

K02-Qual = '022'

K02-Document = reference number

KU5-qualifier = '002'

KU5-amount = '52.00'

KU5-currency = 'USD'

B02-type = 'BB'

B02-accountnum ='33333' (account number must be in T012K in right company code)

B02-Curr = 'USD'

KA1-ParFun = 'AG'

KA1-vendor = '0000000001' customer number for open billing item

PU1-msg name = 'INV'

PU1-number = '9400000003'

PU5 can repeat for deductions and discounts

PU5-qual = '004'

PU5-amount = '52.00'

PU5-curr = 'USD'

DLU5-qual = '001'

DLU5-amount = '52.00'

DLU5-curr = 'USD'

You also need config in the following places to make this work

Financial Accounting (New)-> Bank Accounting-> Business Transactions-> Payment Transactions-> Electronic Bank Statement-> Make Global Settings for Electronic Bank Statement

posting rule -

debit posting key '40'

account symbol what ever you set up

document type 'DZ'

posting type '8'

assign accounts symbol

account symbol what ever you set up

g/l account '++++111000' this is petty cash sap standard, you can pick something else

Financial Accounting (New)-> Accounts Receivable and Accounts Payable-> Business Transactions-> Incoming Payments-> Electronic Incoming Payments-> Payment Advice Notes-> Define Further Processing of Payment Advice Notes

specifically

payment advice type = '06'

account type = 'D'

Company code

sign = '+'

accounting post automatically 'X'

In edi too 'X'

posting rule 'Zxxx'