@Angelica Mae Segador-Oracle Yes, I do.

@Patrick Fresnosa-Oracle thanks for looking into this. Yes, the purpose of crediting the Advanced Intercompany Journal Entry is to record it as loan (re)payment from subsidiary B and apply it to clear I/C Open Receivables on Subsidiary A who originally loaned the cash to Subsidiary B.

@Patrick Fresnosa-Oracle Steps taken: Journal entries created for payments received Open I/C Customer > Accept Payment Select A/R account Select credits Update Payment Amount Click Save Result: Notification "you must apply the credits/deposits to at least one item"

@Clarisa De Torres-Oracle thank you! How about subprojects? Any guidance on the maximum number for a single project? Thanks.

Thanks @Elychelle Gulen-Oracle. How about the payment file template for the bill payment file? That is the real concern.

What is the syntax for the LookUp and will that link various subtasks/milestones in NS to the appropriate Phases in OpenAir?

Hello @Michaela Christova-Oracle Yes, we have the checkbox/internal switch "Enable NetSuite Task Import and Update" enabled. No, we are not getting any errors and this test is in the sandbox environment. What field do we select under NetSuite field to map to project_task.parent_id? Also, Project_task.is_a_phase? If using…

@Patrick Fresnosa-Oracle The Revenue is referring to charges that have been created/Revenue Arrangements. We are yet to post the journal but the arrangements have been generated.

@Patrick Fresnosa-Oracle can we get the cost to show on the Project P&L at Picking or Packing stage before Shipped? Shipped shows as Actual Cost. We want Inventory Items to show as Committed Cost before the "Shipped" stage.

@Patrick Fresnosa-Oracle primarily cost! We want it to impact as early as possible, preferably once we pick the item, we would like it to reflect in Committed Cost on the project P&L.

I will need to explore and see. Thanks @Tigran Shahnazaryan and @Patrick Fresnosa-Oracle

@Patrick Fresnosa-Oracle no, I am not trying to create two separate orders. The Sales order is created from an Estimate and I later link a Project to the SO at header level.

Here is an update. After I updated the Project Profitability configuration by adding Other Asset and Other Current Asset to the three Cost rows, inventory items in Purchase Orders started showing up as Committed or Actual Cost depending on the stage of the Purchase Order. However, fulfilling a Sales Order linked to the…

Yes, some assembly items are used in both ways.

both scenarios apply.

Yes there are many assemblies and each is a final product

@Tigran Shahnazaryan what are those options? Plus how does NetSuite handle a Project that involves service items, inventory items and non-inventory items. Thanks.

@Patrick Fresnosa-Oracle we have service items, non-inventory items and inventory items used on the same Project and would like to mark up the non-inventory and service items. Removing Purchase Charge rules will impart this or not?

@Brian Stisser the assemblies are being built and the inventory items purchased and/or drawn from inventory.

Update: Transaction Number is populated if Main Line = Yes, but that takes away the GL impact lines. I tried a few formula (text) syntax in Results but no luck.

Thanks @Elychelle Gulen-Oracle I tried both steps but Applying Transaction Fields... = Transaction Number | Bill Payment Number is coming as blank even though the bills have related bill payments.

@Patrick Fresnosa-Oracle Bill Rate Card Charge Record Invoice

@Kristoffer Viray-Oracle Below is the screenshot. It is the Billable Items and Billable Expenses subtabs on the invoice form (edit mode). If the tabs cannot be customized or filtered, is there a system preference to exclude Paid in full vendor bills from Billable Items subtab? It is hard sorting through tens of thousands…

@Patrick Fresnosa-Oracle Yes, it is related to projects. Charge based billing with billing rate card attached to the Project.

Thank you @Patrick Fresnosa-Oracle Is there any way to exclude Paid in full vendor bills from Billable Items folder outside of customizing the tab? Maybe a system setting. Regards.

@Jack Daryl Espiel-Oracle thank you!

@Jack Daryl Espiel-Oracle thank you for the detailed response. Your response is clear except for the section - " or when setting the fields to the same values already assigned to them. " Please clarify. The fields are not null on the Job record, so where is the workflow getting the null values from?

@Ivy Lopez-Oracle never mind. It is a permission issue. Added Payment File Template permission to the role and that resolved the issue. That wasn't required before we installed the UK Localization SuiteApp.

@Patrick Fresnosa-Oracle let me try this and get back to you. Thanks for the suggestion.

@Elychelle Gulen-Oracle thanks for the feedback. At least I know I wasn't missing a trick.