4,624
Hi,
I am checking the trail balance and customer aging report as on 31 may 2017, but unfortunately both reports are showing different closing balance as on 31 may 2017.
Trail Balance is showing as below: $827,275.21
But Customer Aging is showing: $847623.47
Then i checked Customer balance list with credit limit and it showing me same balance as Trail balance: $827875.21
Please advice how can i identify which report showing incorrect balance?
*This post is locked for comments
Thanks Muthusamy. I corrected my code by below line:
transBuffer.LastSettleDate = str2Date("5/30/2017",213);
transBuffer.Closed = str2Date("5/30/2017",213);
It works and now issue is resolved . Both trail balance and customer aging reports are matching.
Thanks to all for your help. Really appreciated
Thanks Ludwig & Muthusamy,
Today, i am running code (shared above & corrected by David) , but its not updating the date field (LastSettlementDate & Closed field). As i have used Str2DateDMY function even i tried str2Date Function as well but no result. my code looks like below:
static void CustTransUpdateRecordTest(Args _args)
{
// update records in custTrans table for settle transaction
CustTrans transBuffer;
custTransOpen custTransOpen;
;
ttsBegin;
while select forUpdate transBuffer where transBuffer.AccountNum == "RCA-0000068" &&
transBuffer.Voucher == "RFV-3008962"
{
// delete custTransOpen
delete_from custTransOpen where custTransOpen.AccountNum == transBuffer.AccountNum &&
custTransOpen.RefRecId == transBuffer.RecId;
// update CustTrans records
transBuffer.SettleAmountCur = 5498.81;
transBuffer.SettleAmountMST = 5498.81;
transBuffer.LastSettleAccountNum = "RCA-0000068";
transBuffer.LastSettleCompany = "xxx";
transBuffer.LastSettleDate = str2Date("5/30/2017",123);
transBuffer.LastSettleVoucher = ""LTR-4001575";
transBuffer.Closed = str2Date("5/30/2017",123);
transBuffer.update();
}
ttsCommit;
info(" Record are succesfully updated");
}
Please suggest
Hi Visvash Walia,
In this case you can only avoid users from using this button by 'hiding' it for example through means of security.
Best regards,
Ludwig
Hi Visvash,
Yes, You can use the update code which is mentioned here by David.
After the Update of CustTrans table, Check the related record in CustSettlement table and verify the same (Offset Vouchers, Settlement related fields, TransRecId, etc).
Synchronize the table data.
Then, Check the impacts in Customer --> Transactions form, Customer balance form and Customer statement report.
Thanks,
Hi,
Not absolutely sure if customer and vendor transactions can be reversed from the transactions forms in AR/AP without that parameter active. Is the reversal button available in your environment in the AR/AP transaction forms?
Ludwig
Thanks Ludwig.
What i am not understanding is how AX allows reverse transactions from that option
(in custTrans form) if it is already deactivated in GL parameters ,...did it would be reason for this issue?
Please provide highlight on this
Hi Visvash Walia,
Yes, I referred to this parameter. If it is deactivated, corrections have to be made manually. As an example you originally post
DR: Account 123
CR: Account 456
Amount $5
To get this corrected you can manually enter a voucher
DR: Account 123
CR: Account 456
Amount -$5
(Alternatively you can also switch the DR and CR account and post the correction with a 'positive' amount).
Best regards,
Ludwig
Sure Ludwig, I haven't try to run the code now , before that i am digging into the issue. Thanks for suggestion . Definitely , i have to do correction by running code. But i want to ask that are you talking about below parameter , if so it is already deactivated :
if i would deactivate the reversal parameter then , how they do manual corrections, please suggest so i can advice them
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (