If anyone needs help with inventory imports let me know. Hi Andrew, can you share how you solved the problem, did you create a new import scenario or there is an existing import scenario can serve the purpose.Thank you
in the real situation, the rebate is not only for one product, and involve multipe purchase receipt, so manually adjust the purchase receipt is not a solution we can afford
@jay13 Can you please explain what is the requirement? If it is the same as above, you can extend the SOOrderEntry Graph, and add the above so that information will be displayed on the Grid Footer. @Naveen Boga sorry i am quite new to customization, do you here ? (ingore the project name)
Hi @ryanmoon32 Yes, it is possible with small customization. Please find the sample code below. public virtual void SOLine_Availability_FieldSelecting(PXCache sender, PXFieldSelectingEventArgs e, PXFieldSelecting invokeBaseHandler) { invokeBaseHandler(sender, e);// add logic to bring the Sales Price //var lastSalesPriceValue = GetLastSalesPrice(); e.ReturnValue = "Last Sales Price" + lastSalesPriceValue; } @Naveen Boga i have similar ideas, can you share more about how to make it happen, how do i use the code. Thank you
Hello, Enter a Credit Adjustment for the amount to write off, and then apply the remaining Prepayment amount to the Credit Adjustment. A Credit adjustment credits the AP liability account and debits whatever expense you enter on the detail line. Ask your accountant what account to use on the debit. Hi @laura01 thank you for your reply, i encountered an error when doing so, not sure what happen.The error message is reference number can not be empty, yet i doesn’t allow me to put a reference number.i already raised a support case.
Hi @jay13 You are aware of these issues I believe. The idea is already posted in the Ideas section of this community. Thanks Hi @manikantad18 , Yes i know that if the balance is a positive number, i can create a debit adjustment and apply to the balance. In the scenario of this new post is that the balance is a negative number, i couldnt find a way to clear those balance.
Was going to ask whether you’d grouped your query. Unfortunately with grouping it’s not possible to do what you want. You need the Sort function to be aggregated by the groups as well but you can’t use aggregate functions in Sort. You’d need to rewrite this as a report with Report Designer. Hi Royce,Alright, thank you again.
I used this for the Sorting formula and it worked as expected. =IIf([ARInvoice.DocType] = 'CRM', -1, 1) * [ARInvoice.DocBal] It’s the same formula I used for Balance Signed column above. Hi Royce,Thanks for your reply.I think your case is different from mine. Your case is sorting by individual invoice balance, but i grouped the document total by customers.
Hi @jay13! I think for this issue the sorting is not meant to accommodate an IIF statement, at least not that I’ve ever seen. I would recommend in the expression to multiply by -1 instead of just adding a - to the value. I’m not sure if it makes a difference, but this is the most common way I’ve seen to invert the value. It seems like the formula is just deciding on if to make it negative or not and not necessarily related to sorting, so I think it’s best to leave the formula on the results grid and just sort descending by the DocBal field. Have you already tried something like this? HI Benjamin,Thank you for your reply.I add a “TEST” column in the resulting grid, not sure whether this is what you mean, and i made the sorting by “ARInvoice.docBal” descending, most of the results are able to sort by order, but still have some records didtnt follow order, attached some screenshots.
@laura01 Thank you for your reply.So there is no easier way to do so, we have to create a debit adjustment for $0.02.
hello @laura01 ,Thank you for your reply, attached is the Purchase Order Screen Shot and Bank Reconciliation page
Already have an account? Login
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.