Hello @userquery You need to go to Customer Invoice window (sales > invoicing > customer invoice) and cancel the preliminary invoice. Cancel Invoice is only available for Preliminary invoices and IFS version 10 or higher.Hope this helps
Hello @ronhu I think the issue is with PO rather than invoice itself. Can you check the PO currency and domestic amounts on the matching window or on the PO lines? Thanks
Hello @Israel de la Cruz You can create a quick report from posting_proposal_auth view. I created a sample report for you selectp.company as "COMPANY", ifsapp.supplier_info_api.get_name(ifsapp.invoice_api.get_identity(p.company,p.invoice_id)) as "SUPPLIER ID",ifsapp.invoice_api.get_identity(p.company,p.invoice_id) as "SUPPLIER NAME",ifsapp.invoice_api.get_invoice_no(p.company,p.invoice_id) as "INVOICE NO",p.authorizer_id as "AUTHORIZER",p.user_id as "AUTHORIZED BY",p.date_created as "CREATED",p.change_date as"AUTHORIZED",round(p.change_date-p.date_created, 0) as"DIFF DAYS"from ifsapp.POSTING_PROPOSAL_AUTH p where p.company like '&COMPANY' and p.AUTHORIZER_ID like '&AUTHORIZER' and p.objstate = 'Authorized'
Hello,I just replied the other post you created.Posting Proposal - Is there a way to know how long it takes for an approver to authorize | IFS Community Hope this helps
Hello @s-oflaherty Have you heard about Pagero solution? It works the you want. I attached a document. You can review it.
Hello @Babs There is no such an indicator. But there is LOGICAL_ACCOUNT_TYPE column where similar information is stored. The value C represents Expense/Cost accounts and the value R represents Revenue accounts.Alternatively, you can create a custom field with custom enumeration to store this data on the accounts window.Hope this helps.
Hello @jgrace Query flags are not available in IFS cloud yet. Therefore you will not get a date picker for a quick report. Please review the documentation here. KNOWN LIMITATIONPlease note that due to an implementation constraint, use of query flags and enabling default values for parameters in SQL type Quick Reports is currently unavailable. Even though you could create a Quick Report with query flags and enable default values, it will not be affected when the Quick Report parameter page is shown. Currently there is no workaround solution. Quick Reports - Technical Documentation For IFS Cloud
Hello @andrei.borromeo To my understanding, your posting control setting should be changed. IP19 and PP36 should be distinguished. Basically, system reverse original postings (IP17/IP19) when matching advance invoice with advance payment. Once it is matched, a new transaction line with PP36 posting type using actual current rate.Therefore, I would recommend you split the accounts.IP19 - Unpaid customer advance invoice account (e.g. 2300)PP36 - Customer payment in advance account (e.g.2310)Hope this helps
Hello @Furkan Zengin I think there is misunderstanding of the functionality. What IFS basically does, reverse transactions from advance invoice (IP17/IP19) and create a new ledger transaction (PP36) for advance payment. So actually there is no matching/offsetting between IP19/PP36 ledger transactions.You may get a currency difference only when you match advance payment with a final customer invoice.
Hi @andrei.borromeo I would not call this IFS is unable to recognize. Rather, this is how the functionality is working. And to me it should be the way it is working. What I understand from an advance invoice, it is a reference record that shows me what to be paid in advance for a customer. There is no gain either loss after paying an advance invoice. Therefore it is not stored in balance sheet. A realized FX gain/loss transactions are regulated with PP12/PP13 posting types (tax transactions are not considered for this statement). In your case you only reverse advance invoice record with its original values (IP17.IP19) and create a new record advance payment record (PP36). As I stated in previous post, IP19 and PP36 is not offset each other. Rather when advance invoice is paid then IP19 creates a new transaction generating a PP36 transaction.Hope this is clear
Hello @andrei.borromeo If your project source is the project module then you have 2 options. Either you must give an activity ID when entering the customer invoice. Or you must exclude the GL account from project follow up.This is the IP19 account in my case and I have excluded the account from project follow up. When an account is excluded from project follow up, entering an activity ID when creating a transaction is not permitted. So you wont get such an error.On the other hand, you will not see transactions in project navigator window for this account.Hope this helps
Already have an account? Login
No account yet? Create an account
Enter your 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.