already in progress. Just very frustrated that this could happen!!!

No it it snot a viable solution - given you have to have NO unmatched transactions in the system… The reality is this should have NEVER happened. Totally defeats the purpose of NON GL Impact updates if it is going to cause havoc on bank recs. It really should be considered a defect.

I cant provide a screen shot as there are 900 transactions. There are 70 odd bank accounts affected a CSV update to a journal in a closed period, that has ALLOW non GL changes - should NOT be removing cleared date and cleared flag from the transactions. Thanks lisa

the distribution solution is just adv JEs and that sucks from the perspective you cant send an adv JE to a bank for payment… It should be invoices and vendor bills. The intercompany functionality is not what it should be and we have come up with our own scripted solution!!

intercompany journals can’t be sent to the bank for ach payment. We have built our own workaround but we aren’t the only one with this requirement you have to think about 1099s. It is complicated.

Yeah it is ugly but it gets us what we need it to do… So my normal fiscal calendar will have two periods for the month of August… that is the least of our problems - it is our only way to get retained earnings to calculate correctly on sold entities. Will be voting!

and then i wanted say so i think this is what happens.. Standard shows whereas my special fiscal year shows Does that sound right!

and Partial Payment - so the bill was for 15k, 5k was paid on it - so there is really 10k remaining - we can only see the 10k when we do a main line report - but we need the accounts that the bill was coded to. It could be a two bill - like 7.5k consulting and 7.5k Tax advice - but the open balance is 10k… I know it is…

AND… '<a https://XXXX.app.netsuite.com/app/accounting/transactions/vendbill.nl?id =' || {internalid} || ' target=_blank>Link</a>' What is wrong with this HTML Formular!

The problem is this - main line is FALSE so there is no amount remaining on the line details… So that formula returns NIL. Also how do we get remaining amt in foreign currency? My next issue is a bill has had a credit applied to it. So it is not showing the net amount owing. HELP!

when you look at assembly detail - it put first line into inventory for the item in question and all the other lines are the item used… Basically i want my formular to return TCT12IC08 on all lines…

No. It is an acquisition. Our new owners have legally changed our fiscal year end to be Dec 31st. All our subsidiaries did have a year end of Sept 30th We were acquired on May 15th 24. So our year end is now May 15th 24 and we need a "Stub" year end from May 16th 24 to Dec 31st 2024. My reading says we have to move all…

accounting period for various transactions Company acquired on may 16th 24 So need a calendar year being may 16th to dec 31st 24 Former year end was sept 30th So ready to move transactions so we can modify. But it would seem fix reveals on payment postings can’t be modified by script or mass updates. So asking if that is…

sp. are!!

you ate brilliant. There should be a suite answers on this. It is a classic example of what users would want to do!!

Aqesome dialogue and most appreciated. It would good to see an enhancement for markup on customer billing. I really suspect it is another module. Just trying to work what that is . Fun continues..

Will have to look in to We never charge time. We have a vendor bill in sub b that we tag belonging to sub a. I want to bill it to sub a which I can use the billable tag..but how do I do a markup on billable expenses?? Is this a new module like suite billing or something. I just don't see this . I thought you said an…

Yes it is but Sub B marks up the cost to charge to Sub A and does milestone billing. I just want the markup to eliminate and the actual cost detail to go over to Sub A books so they know what was bought on their behalf.

Let me think… Sub A issues po to Sub b Sub B issues sales order to Sub A Sub B issues PO to external vendors - these costs are in direct relation to the sales order issued to sister company - we need to track these costs to know profit margin… This is all services driven. Ideally we want the actual costs charged to the sub…

So what are the workarounds??? What do others do with this system limitation??

Also what about inventory reports - want users to have access but NOT be able to see any costing information - is this also an enhancement?

Man never ending enhancement list! Thanks for the answer

This formular works for customer deposits… max({amount})-abs(sum((CASE WHEN {applyingtransaction.trandate} BETWEEN to_date('01/01/2016', 'MM/DD/YYYY') AND to_date('12/31/2023', 'MM/DD/YYYY') THEN {applyingtransaction.amount} ELSE 0 END))) Then i thought i need to consider applied to info so tried this as i am dealing with…

exactly - thanks.

To be clear Is just in the header of the sales order. I just want more custom body fields that contains the dollar value of all items on the sales order - based on unit cost on the inventory record, and NOT average cost. I can not use GM analysis as CMSS, Shephard solution is providing other costs associated with the sales…

Why is everything an enhancement!!! So sad.

Sorry - just looked at this. Yes exactly that. i have a sales order - and i want to know gross margin at the header section of the sales order. That is why i need a sum of the line item costs. I want the gross margin to be based on purchase price of the items listed in the sales order and not on average cost.

i have a bunch of open vendor bills and credits that are cancelled out by journals - i do not want to use the user interface to match them all as it will take too long. Therefore i am planning to do it via script. Currently my plan is a NIL bill payment and that seems to be working.

Any thoughts on this??? Gentle followup!

Also what about being able to set the cleared flag via a script and datecleared??? Is that possible - any known workarounds?