Hi @andrei.borromeo ,The above error is coming due to changes in posting controls for this Account. If the Account is added or removed into new posting controls that belong to different types than the current types, then the use of the Account is different.For example, if this Account is previously used only in Account Receivable posting controls then Used in will be updated as Account Receivable. Then if the Account is added to an Accounts Payable posting control it should be changed to General Ledger. If not, the application will throw an exception as mentioned in your issue.To correct this you need to remove the Account from the Revaluation Account list and add it again which will update the correct Used In type.Hope this will help.Regards,Akila
Hi @lisa.gilesAB,You have incorrectly mapped the Variables in the where condition. The view's columns should be the filtering condition, and the variable should be the custom field creation window’s columns. So the select query should be corrected as Order_No = :Source_ref1Line_No = :Source_ref2Release_No = :Source_ref3 Regards,Akila
Hi @Babs ,I believe below will be a reasonably faster query than above.select a.company, a.voucher_type, VOUCHER_TYPE_API.Get_Description(company,voucher_type) VOUCHER_DESCfrom gen_led_voucher_row_tab agroup by a.company, a.voucher_typeRegards,Akila
Hi @Babs ,If this is for a query you can use VOUCHER_TYPE_API.Get_Description(company,voucher_type) method to get the description for voucher type.Regards,Akila
HI @MelTanyaS,Transactions date should be within the From and To date of the Transfer process. Otherwise it will not consider the transactions that does not belong to transfer period. So in your case From and to Date should be 01/04 to 05/04.There are no restrictions on transferring the transactions in current month. But you need to make sure voucher date is correct. Regards,Akila
Hi @BeaLauraA ,Glad to hear the good news.Regards,Akila
Hi @BeaLauraA,It should be the Target LU key, not the Source LU Key. So, the transformation Method should be ORDER_NO=INTERNAL_PO_NO. Regards,Akila
Hi @BeaLauraA,Have you tried INTERNAL_PO_NO as the target LU key as well? I think you could directly link Customer Order also with this setup. I have tried this and worked for me.On an Additional note, Transformation will only show documents that are attached to the Source LU. If the PO attachments are transformed from a different source those will not transformed to a third LU. (Customer Order or Incoming Customer Order)Regards,Akila
Hi @BeaLauraA,I believe you should be able to use CUSTOMER_PO_NO or INTERNAL_PO_NO as the target LU key since this is getting updated with the connected internal PO no in the Inter-site Process.Regards,Akila
Hi Michelle,If the Items are in Inspection status it is not considered for Planning. So if you change the receive case to Receive into Arrival, Inspect at Arrival Receive Case receipt will place the item in Inspection Management, while it is in the Arrival location and the user will have to perform the inspection register before moving to a usable location. However, I’m not sure if this works with MS as I have not tried this with the MS process before. I can confirm this works with other planning functionalities and it does not show in the IPAP as available as well.I hope this will help.Regards,Akila
Hi @ronhu ,I believe this is the Bank Account no in the Cash Account you used when preparing the Payment Order.Regards,Akila
Hi @Yoshini Silva ,As I suspected the issue is caused due to the Blocked status. But, since now the CO is canceled I don’t think you can do anything with the Credit Invoice except remove it using the RMB option. If the customer wants to clear the invoice then you will have to create a manual credit invoice and offset it with the debit invoice.Or If Possible, Post the Credit Invoice forcefully through a DB correction.Hope this will help.Regards,Akila
Hi @Buddhika Kurera ,I was referring to Manual Block or Credit Block in the header. Additionally, I believe the Invoice Blocked option only blocks Final Debit Invoice creation and not the Advance Invoice Creation. So even if the Invoice blocked is enabled you can create Advance Invoices and Advance Credit Invoices without any issue. @Yoshini Silva ‘s question is on the Advance Credit Invoice as per the screenshots.Regards,Akila
Hi @ronhu,Credit invoice details are populated under structured payment information only. So, you can group multiple credit invoices with a debit invoice if the total payment amount is greater than zero. If you select the structured payment option, the output file will generate multiple credit transfer transaction blocks in a grouping.Maximum Occurrence is used to define the no of maximum credit invoices that can be held in a single structured payment block.Hope this helps.Akila
Hi @Yoshini Silva ,If all prerequisites are in order, have you checked the status of the Associated Customer Order? If I remember correctly Application won’t allow you to Print the Invoices if the Order status is Blocked.Hope this will help.Regards,Akila
Hi @ronhu ,The following basic data needs to be done in the “Format Specific Information per Institute” window under your relevant payment method to use credit invoices in an ISO file.In the Payment Institute window, Select your Payment method and RMB > Format Specific Information Per Institute. And enable Allow Credit Grouping functionality in the Credit Notes Grouping section. This will group credit invoices with the debit invoices in the ISO file.Hope this will help to resolve your issue.Regards,Akila
Hi @jruff ,You can defined default location in the Inventory Part window (Default Locations tab) which will automatically use when receiving the PO based on the receiving case.Following is the order that system looks for the default Location.A default location for the inventory part A default location for the site The location last used Hope this will help.Regards,Akila
Hi Arend,Electronic payment method option enable based on the Payment format. What is the payment format you are using? Generally Payment formats which will generate a payment file will enable Electronic payment address while payment formats that does not require account information such as Check will not enable the RMB option. You can check which payment formats has this by using RMB option Payment address presentation in the Payment formats window records. You can change the Payment address presentation using this RMB as well.I agree with your second point and that is the reason we do not recommend using bank account as a matching parameter most of the time. But all of the Customer related parameters have same limitation and control. It is hard to define a static logic to look up the customer as different countries has different setup in related to IBAN, Bank Account or Tax IDs. However, if you can convince the customer to refer a fixed unique reverence no for each customer when maki
Hi @Donna V ,You have two options;Reactivate the user account and reapprove the rejected steps. Approval routings are connected through the Person ID. You can reapprove the rejected step by connecting the Old User’s person to an Active user account in the Person window. First, you need to remove the active user’s user id from the connected person id and then connect that user id to the other person who has already left the company. And then using the Active user account you can Approve the rejected steps. After this you, need to revert the setup in the person window.But since both are security-related options you will require Audit/IT approval based on your company policies.Hope this will help.Regards,Akila
Hi @Arend ,You need to define the Electronic payment address in the customer with the bank account (Account Number column) information for that Customer under the above payment method. Additionally in the External Payment parameter window you need to set the matching parameters as shown above. For the length column you need to provide the Length of Bank account number and for Interval From and To number columns Minimum and Maximum values that could be available for the bank account. For example if the Length of Bank account is 6 you can provide 000000 to 999999 for the From and To interval column respectively. Hope this will help.Regards,Akila
Hi Adri,Yes, This is the expected behavior. No Tax means no calculation will be done as Tax and No tax postings will be triggered. If you want to trigger tax posting then Tax type should be VAT and you can define the percentage as Zero. This will trigger tax postings and tax transactions which will fetch for Tax reporting.Hope this will help.Regards,Akila
Hi Lashini,I haven’t done a setup in longtime, But if my memory serves me correctly, Row should be in C18 and header should be C71. 🙂Regards,Akila
Hi Lanka,I do not recall a standard functionality that can trigger a mail to send an email for item expiration. But there are couple of workarounds that you can try to achieve this requirement.Create a custom report to get the expired items with a date parameter as input and then schedule that report to generate and send as a e mail. Create a custom API to generate the expired items list and then return the count of records as a output. Then using a IF condition you can trigger the email sending by using Command_SYS.Mail() function if the count is greater than Zero with the list of expired item list.Hope this will help.Regards,Akila
Hi Lashini,These tags are for Code Part Values which should update in the invoice as per the agreement between trade partner who sending the invoice. Values should be separated by semicolon. Row is for line level values.Hope this will help.Regards,Akila
Hi @Georgina.mitchell ,I believe you need to setup a document series in Payment Documents> Customer Payment Receipt category.Hope this will help.Regards,Akila
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.
