Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Najeem JanatAli]

Hi All

Looking for assistance with Atlas custom template from ATLAS website. Template is to upload Customers adjustment in bulk. Either template is error out on:

-On Account Type “Customer” as it accept bank, ledger and vendor, not customer. Although this template is build for Customer

-Customer number / ID, in case if it accept Account type customer but error out at Customer ID/number

Multiple templates are attached to achieve same goal to upload customer adjustments

Also error message attached as well

Thanks and kind regards

[Kerstin Newman]

Hi Najeem,

We have been experimenting with the General Journal Upload and had a lot of support from the Atlas support person that was assigned to our account at the time. I am not sure we could have figured any of this out without their help as the upload seems to be pretty finicky and very specific.

All that to say – If you create an adjustment in the UI, you probably have to specify where the offset goes, does it offset to a vendor account, a customer account, a ledger account? And then you would just try out all the options until it loads, and loads properly. It was a lot of trial and error for us as well, but eventually we got it working. It’s hard too because every company sets up their environments differently, so I am not sure there is a lot of generic advice that would apply to your situation specifically.

Good luck!

——————————
Kerstin Newman
Business Analyst
StarTech.com
London ON
——————————
——————————————-

[Najeem JanatAli]

Hi Kerstin

Tried several times it accept Account type vendor but not customer. Contacted ATLAS support as well, however they sent a link relating to interco journal, which require update in AOT, 
GL – Post to accounts types other than Ledger Eg. Inter company Journal / Account Type must be ledger

Not comfortable with updating in AOT

Thanks and best regards——————————————-

[Andrew Russell]

I’ve seen that error before, have a look at this (it’s not an Atlas scenario so it doesn’t match your problem exactly):
https://dynamicsax-fico.com/2015/08/14/excel-add-in-enhancements-1/

Can you process the journal on that JournalName from within AX or do you get the same error?
Can you upload the journal if you point it to a different JournalName which is not JournalType=Daily?

I’ve found Atlas support to be very helpful.

——————————
Andrew Russell
direct wines
Theale
——————————
——————————————-

[Marlene Rivinus]

We encountered similar scenario with Atlas upload but due to data we were trying to add to the Project tab in GL journal line. Same error message; ultimately resolved by updating AOT for the Class LedgerJournalTransType as outlined on this URL Andrew has mentioned in this post.  
 If you can point to a Test/Sandbox environment try that first and/or contact your AX partner for support.

?

——————————
Marlene Rivinus
Midrex Technologies Inc
Charlotte NC
——————————
——————————————-

[Najeem JanatAli]

Thanks Marlene

Atlas support also sent the link to update in AOT:
GL – Post to accounts types other than Ledger Eg. Inter company Journal / Account Type must be ledger

To update in AOT have to go through approval and justification process and it wont look good as it accept vendor and not customer as account type

best regards

——————————————-

[Najeem JanatAli]

Hi Andrew

Processing Journal general in AX with Account type “Ledger” and Account type “Customer” work perfectly, Since finance department have 100s of lines to upload and ATLAS template is the only way, but its not accepting Customer as account type, if it  accept customer account type then it fails at Customer number/ID under account

Best regards——————————————-

[Arush Kuthiala]

Hi Najeem

One way around this error is to press the Gear in your upload template and disable validation. I would only use this for Standard Users who cannot make changes and lock down your upload fields carefully.

Thanks, 

——————————
Arush Kuthiala
Western Computer
Toronto ON
——————————
——————————————-

[Steve Latta]

Hello Najeem,

Like all the Atlas templates, ?it is designed to work with the USMF Contoso demo company. You will need to modify it somewhat to connect to your test or production environments. And, using a daily journal type is correct – or at least it should work okay.

First, make sure you go to Tools>Manage Data Sources and point it to your Contoso demo company or test environment. Once you do that, your Company lookup should populate correctly. Once you select your Company, the journal lookup should pull a list of possible daily GL journal types from your environment. You need to make sure you have at least 1 daily general journal type already configured in your environment so you’ll have something to pick. Once you pick that, the template will be able to fill in the fields in column A. You’ll probably also need to select a value for the “Approved by” field. Make sure you have some workers set up in your environment for that company.

Next, you’ll on notice some of the templates there are 2 columns that say “Your FinDim1” and “Your FinDim2”. You’ll need to click the “Upload” button and edit the existing template to point those to your additional GL financial dimensions – Company, Department, etc. Your screenshot only has values in the main account column, which probably isn’t accurate in terms of your GL account structure. If you only have 1 financial dimension besides the main account, you can delete the column for “Your FinDim2”. If you need more than 2, add additional columns and link them to your additional dimensions. Hint: rename the column names in the table to match the names of your additional dimension names. At least one of the templates didn’t have columns for these additional financial dimensions. If you don’t pull in all your required financial dimensions, the upload will fail at the validation step. You do NOT want to turn off validation. Make sure you are populating any additional financial dimensions your GL account structure requires for the offset account you decide to use.

The main account (offset) number needs to be something out of your chart of accounts. I recommend either using your actual accounts receivable GL account or some kind of clearing account. Either way, once you upload the rest of your GL opening balances, you’ll probably need to do an offsetting journal entry someplace to keep your AR balance from being doubled or to zero out the balance in the clearing account. (If you use your actual AR account, your upload will net to zero in that account and the only balance in it will come from your GL opening balance upload. If you use a clearing account as the offset, when you load your GL opening balances, your AR balance will be doubled and you need to offset the extra against the clearing account. Which you do depends on how your accountants would prefer to track it).

Finally, looking at the “Opening Customer Transactions” template, I can see where the Journal Lines (LEDGERJOURNALTRANS) Account Type is hard coded to “Cust”. However, the Offset Account Type field isn’t being populated. It may be that because the template is mapping to the OffsetLedgerDimension_MainAccount field, that the offset account type is being set to “Ledger” automatically. However, it won’t hurt to add that field to the query and hard code in “Ledger” the same way “Cust” is hard coded for AccountType.

——————————
Steve Latta
Accountant
Ortec, Inc.
Easley SC
——————————
——————————————-

[Deb Salyer]

unfortunately some of the templates are missing information or the snippit doesnt connect correctly.  I used the GL upload and changed the account type to customer and added invoice, invoice date and due date

——————————
Deb Salyer
DS Erp Inc
Sarasota FL
941-351-2990
deb@dserpinc.com
——————————
——————————————-

[Najeem JanatAli]

Hi Deb

Also tried General upload template it worked with Ledger and vendor. When tested for Ledger and customer it didnt worked and error message : Vendor, Ledger and bank is acceptable and customer is not

Would you mind sharing your template

thanks and kind regards——————————————-