Dear All,Can some explain how the sales order intake process work and when data is sored in the table IFSINFO.SALES_SUMMARY_PCKCOMP_V2_TAB?We've made a customer report based on a view called: IFSINFO.SALES_SUMMARY_PCKCOMP_V2The view contains this:CREATE OR REPLACE VIEW IFSINFO.SALES_SUMMARY_PCKCOMP_V2 ASSELECT "LINE_TYPE","ORDER_NO","STATE","LINE_NO","REL_NO","LINE_ITEM_NO","LINE_STATE","CONTRACT","ORDER_TYPE","CUSTOMER_NO","CUSTOMER_NAME","CATALOG_NO","CATALOG_DESC","COUNTRY_CODE","REGION_CODE","ADDRESS_STATE","SALESMAN_CODE","S_GROUP","T_SALES_QTY","TOTAL_SALES","TOTAL_COSTS","GROSS_PROFIT","REPORT_DATE" FROM IFSINFO.SALES_SUMMARY_PCKCOMP_V2_TAB; When we use this view we only see data till a certain dateWhen we look in the table we also see no data with a report date later than that certain date. So my question is how is the table IFSINFO.SALES_SUMMARY_PCKCOMP_V2_TAB normaly filled?What proces or processes must be run to dow that? Kind regards Raymond
Dear all, A customer of me has cancelled a Purchase order that is related to Work order in this way. This has led to this situation on the WOHow can we remove / correct this situation?I thouged via the PO but that is cancelled.Anyone an idea?Regards,Raymond
Hello All, We want to Create a Credit invoice for a Customer invoice.We do that via the RMB option Create Credit invoice.The background job that was created gave the following message:ORA-20111: CustomerOrder.NOTEXIST2: The Customer Order object does not exist.When I looked for the customer order I found-out that it's gone.When I spoke to customer they told me that they had done a clean-up action for customer orders.Due to that action several Customer order are removed from the system. How can you create a Credit Invoice in this case? Kind RegardsRaymond
Dear All,How can we add the project in the posting for posting type M1 when we do a Projects Dilverables Shipment, Inventory in IFSAPPs 10? In APPs10 it's not picked but wehn we setup the same configuration in a CLOUD enviroment it's picked up. Are there new features added to cloud so that's possible?Regards,Raymond
Dear All, Is there a possibilty to send a reminder to a customer about an unpaid invoice that didn't exceed the Due date? For example.The due date of a customer invoice is 31-12-2021. As reminder we would like to send a remninder at 20-12-2021.Can something be set-up in IFS with Reminder templates? Regards Raymond
Dear all,In the deprecication proposal the main object is not picked up any more while it still has a value and active. Why is that?An object is created in November 2022. 2 deprecation runs has been done on this object.In January 2023 an additional investment has been done on the object.To realise this a new object is made and, on that object, the original object is mentioned as a main object.When I make a new depreciation proposal the new object is selected and the old one not. Even when I give in only the original object as selection parameter the new object is selected. Why is that?The depreciation value is based on the new object.What must be done so that the original object is also picked up in the depreciation proposal.Additinal infomation:The log of the deprication runs tells this:For the new object a M voucher is used. Regards Raymond Orignal object
Dear All, Is it possible to change the default values of the dialog screenUpdate Sales Price Lists from Base Prices?The filtered By fields may not have a value Regards,Raymond
Dear all,Is it possible to cancel a preliminairy invoice from a work order?I've got a situation where a prelimanairy invoices is created from a work order. This invoice however is incorrect and needs to be cancelled.What is the best way to do that? RegardsRaymond
Dear All,How can you make a Correction Tax Proposal? What does the correction Proposal Select? All transactions or only the transactions that are changed and later fetched transaction via Fetch Tax ledger Info? Thanks in advance for your reaction.Regards Raymond
Hello All, Can some explain the funciton of the field Mpccom_Accounting_id in the view: GEN_LED_VOUCHER_ROW_UNION_QRY. I have a situation where 2 different voucher_number which have the same voucher_type (MPR)have the same value in the Mpccom_Accounting_idOn voucher is created in Oktober 2022 and the otherone in November 2022.Is it normal that there duplicates in the field Mpccom_Accounting_id when vocuher number are different?How can that happen?How to solve that?Regards,Raymond
Dear All, How can I change / define the NOTC (nature of the transaction code) used in the intrastat report?
Hi all, How to use IBAn and domestic bank account in IFS APP 10 for one bank On this pagehttp://powerace.ifscloud.net/ifsdoc/documentation/en/TMCashBook/BasicDataReq/CBBasicDataReqBE.htm Is described how you must work when a bank uses IBAN and domestic bank account. When I configure that i get the following error when i look at external File load ID So i've removed one of the account numbers and the processing of the bank file worked. How can we use both? Kind regards, Raymond
Good day, Is it possible to definea specific File template for a specific Country for the SAF-T files? For a company in Portugal I have to define the SAF-T files in IFSAPP 9The system now only has one File Template.How can I import more templates and where can I get them or do I have to define them? Kind Regards,Raymond
Good day,For a customer of my I need to implement the ACTUD and QR-code for a company in Portugal.Does anyone know how to get the AT-Validation Code?Must you do the buy using the webservice of the AT? I've also installed the localization of Portugal for APPS9. The customer is using IFSAPP 9Thank in advance for the answersRegards,Raymond
Dear all, Is ther a way to un GL Voucher Rows Analysis and GL BALANCE ANALYSIS over multi companies?or do you must make a custom report for it? Regards Raymond
Deat All, In IFSAPP 10:When parts are recieved on a project Posting Type M1 is used to increase the Inventory and a Project ID can be added as code part to this booking.When this Parts is develiverd via a shipment the account value will be decreased. Herefor also posting type M1 is used. But no code part Project can't be given.So in time you see this for the project on an account. First after receiving the parts.:After shipment you see this on the account:Is it possible to also fill the project when you do a Shipment? Thanks in advance for the response Kind regards.RL Groener
Dear all, During the financial completion of a project a customer is facing an error. What migth be a reason why this is coming?Does anyone has a clue where to look and what to do? Regards Raymond
Dear All,During the authorisation of a Purchase order the following message appears. This po has got a new revision, lines are cancelled but is still availible in the list of unauthorized Purchase orders.Does anyone has idea why this message occours and what must be done to remove it? RegardsRL Groener
Dear all, Why can't I define a customer ID?When if want to give an cusmoter id i get this message: Where does is come from an how can you avoid it?
Dear all,How can you cancel a customer order that has staged billing and where one of the stages is paid.See screen print belowThe order has staged Billing. and the first stage is already paid.What is the best way that led to a situtation so that the order can be cancelled?
Dear all,How to process Vouchers with this Error : Currency HKD is missing or has invalid time interval?Situation:An Supplier inovice was booked with the currency code HKD with an invoice date that's earlier than the valid date of thecurrency rate. So after this more currency rates are added to the system aslo with valid from date before the invoice date.Then tried to apporve the vouchers but they still have the same errorHow to process these vouchers? Voucher with errorCurrency ratesSupplier invoice
Dear all,I'm facing an issue with Write-off in a customer offset using APPS9.I've definedThe following write-off codes.Defined the posting control for pp16 and pp17Details PP16:Details PP17:When i want to do a write-off in customer offset:And select a value from the LOVNo values are availible.How can this happen?
Dear, I've goy a situation at a customer where an CUPIA is first used in an offset on ADand after that is same CUPIA used for 2 CD'sHow's that possible?:Is there no security that you can't use an USED CUPIA again?See images below: Offset of the CUPIA against the AD First offset CUPIA agianst CD.second offset CUPIA against CD
Hello All,Can some tell me how you can match a CUPOA in USD with an invoice in EUR?The company currency is EUR:Customer invoice in EURPayment on account in USDFor a customer we got the following situation We want to match the invoice with the payment on Account. An offset is no option because of different currecncy.Is ther an other way? Regards,Raymond
Dear all,I've got a situation fro a customer where we can't close a Sales contract due to the fact that an application for payment still has the status Approved. how can we solve that? See the screenshot of the application for Payment:The invoice status is Fully invoiced.At the tab Invoice we see that the the invoice has the status Paid posted and is marked as Fully paid/ used. How to solve this so that Application for payment will get the status Fully Paid and the sales contract can be closed?
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.
