Import Payments (Customer) in AX4/AX2009

skumar

Hi,

I am running version 4 and 2009. On the customer payment screen under functions I have Import Payments option, also on the setup of payment methods I can choose file types for exporting and importing (custIn Format 1, DebitDirect, etc for import types). what I am trying to figure out is how this exactly works and can I import a settlement from a file using these functions. I don't know how to set this up. I tried AX-help but it doesn't help much.

Does anyone have any idea?

AdamRoue

On the method of payment record there is a file format tab, it all stems from there.

skumar

Adam,

I already set the file format in methods of payment. I could dig some info after my initial post and these are my findings:
1. AX-Class name is CustInPaymBank1. File format is 'comma-separated' - does it mean i can create a text file (notepad?) with values separated by commas?
2. Some of the fields are:
str 3 point;
str 10 collectionTime;
str 10 orderingNum;
str 8 vendNum;
CustAccount accountNum;
PaymId paymId;
Amount amount;
date inPaymentDate;
date postingDate;
I know how to fill some but dont know point, orderingNum, VendNum, PaymId.
3. I tried to create a text file with some meaningful values but got an error message that 'Error loading file'.

Hope this helps.

AdamRoue

The class is defined for a specific format, therefore the import file has to be in that format for the import to work.

You are not creating the text file with AX, this is the payment for vendors, you are trying to process customer payments, so they give it to you in the format, you then run the process. I have done this with vendors but not with customers, but I guess the principle is the same.

skumar

Adam,

Thats surprising because class name is 'Cust In Paym...' and I thought its related to customer payments.

I linked 'custIn Format 1 (Test)' for 'Import Format' to one of the Methods of payment. May I know which class should I look for the related fields and file format?

Cheers
Phani

AdamRoue

Hi Phani

It should not really be surprising, how do you expect AX to know the format of the import file? You need to tell it this with an appropriate class definition. On the AP side these are always written by developers mapped to the requirements of the Banking software. For you the reverse is true, get the file, and create a class to map this to AX. The one you are looking at is related to customer payments, but it needs you to provide it in exactly the file format the class is written for. You can also treat this as a starting point to develop your own class to meet the import format.

Basically you have two choices:
i) Format your text file to meet the structural requirements of the class you are using.
ii) Develop a class to match the structure of the file you have

skumar

Adam,

Yep, I understand your point. From the beginning, I am trying to map my text file (option-1 from your reply) to suit AX-class format but I keep getting the error message 'Error in file loaded'. I tried text, csv and excel formats to fill in the same formats what AX-class wants (I guess). Please check the content of the text file below (tried with and without quotes) and let me know if I am wrong somewhere:
'abc','20','00285_042','','4000','M',10,'06/07/2009','07/07/2009',

Please note that value of commaFile is always having 'null' when I reach 'while (commaFile)' in my debugging of class CustInPaymBank1 under fromDisk2Journal.

AdamRoue

Hi Phani

You will need to get a developer to analyse the class and the requirements, I am not a developer so would not know where to start and what to check.

What I do know is you are very unlikely to find a match by guessing at the format