Hi Thomas/Ieva,Thankyou for your help so far! I did think the balancing should happen automatically however when we have tested the upload and only included 1 posting line per item, we are unable to progress the posting proposal past ‘PrelPosted’ as when you go into the ‘Authorize’ tab on the posting proposal, there is nothing to authorize, see screenshot. This is the ‘Authorize’ tab on the same posting proposal: Also, as we are using the STDSIN1 template, there are only 2 columns you can enter amounts in on a P record: the ‘Curr Amount’ column and the ‘Dom Amount’ column. I was entering the negative amount in ‘Curr Amount’ and leaving ‘Dom Amount’ blank and this was giving me the error mentioned in previous message.Again, many thanks for your advice!
Hi Thomas/Ieva,We are looking at uploading the invoices with 2 posting lines per invoice item, do you know if it’s possible to have one of these posting lines with a negative amount?The 2 posting lines are: 1 is for the item amount, for example 100.00 so the other posting line would need to be -100.00 in order to balance the posting proposal. I keep getting an error of ‘Invalid value format or invalid decimal symbol in the loaded file’ and wondered if it’s because of the negative amount on the second posting line?Many thanks!
Thanks for your quick response Ieva! In your second option you say to upload the invoices with the postings - what do you mean by this? We are using the STDSIN1 template as each invoice has multiple lines with costs which need to be posted to different accounts so each invoice is being uploaded with a P type record as well as H and I type records. Should we be adding 2 P type records per item (I type record) instead of 1 to balance?Many thanks for your advice.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.