You’re offline. This is a read only version of the page.
935
I have a single file that is being imported into GP for Cash Receipts there are no account numbers on the import file. But when I try to add the source field for the distribution record I don't get a balanced entry. The Distribution has an acct of using constant ****, debit amt and nothing for the credit. If I select a credit amt it gives me debit and credit amount error because it is going to the same constant account. If I take out the account number and use default in options then it will work, but I don't get the other column information like doc reference. Each time I try to make changes to the options for one particular field it changes for call. Any suggestions?
*This post is locked for comments
Yeah, what Leslie said :)
Hi KPW,
I may not be understanding this correctly, so I'm basing my answer on these presumptions. Your import is set up such that you are using a constant in the Debit Amount destination field and you have the credit amount field set at 'Use Default'. You have tried to select a field from your source document for the credit amount, but when you do that, it wants to use the same value for both fields. Your desire is to use a constant for the debit side, but not the credit side. I'm thinking you might sometimes want to provide the credit account, but you want it to use the default if no amount is provided.
I feel certain the above is not correct because it doesn't make any sense to me. Let me tell you my general understanding of how to import the distribution accounts.
First, you need to define a different source for the Distributions. It can be the same physical file, but it needs to be a separate source. If you supply a constant for the debit amount and nothing for the credit amount, make sure you have the credit amount set to 'use default'. If you are going to supply a few credit amount fields in your source, but you want it to use the default for those records where you have no credit amount in the source, you need to tell the system what you want to do with those entries. You can do that. Look at the bottom of the column on the left side of the window and make sure the 'If Null' setting is set to 'Use Default'.
Kind regards,
Leslie
This is one of those scenarios where you can't have your cake and eat it too. If you're not supplying account numbers in the source file, then you have no choice but to use Defaults in your account fields, or you need to supply constants for both the debit and credit fields.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (