https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hi - I'm trying to create a `Vendor Prepayment` in...
# accounting
m
Hi - I'm trying to create a 
Vendor Prepayment
in NetSuite. The 
Prepayment Account
field seems to be always pre-defaulted from the respective subsidiary's 
Vendor Prepayment Account
-- is there a way to choose a different account when a 
Vendor Prepayment
is being created?
m
Are u tried to edit on the subsidiary record the VP account ? Or it’s grey out ?
m
I can. But I want to be able to choose for each individual vendor prepayment
m
Ahh you cannot choose I think You can only define the vp account on accounting preference or by subsidiary Maybe by script you can do what you need
m
script will not work - I tested multiple options there
m
I think it’s possible Create custom field with the list of accounts. Once a value is selected in this custom field, the script will modify the vendor pre-payment account in the subsdiary record. So when saving the VP the account used will be the selected account in your custom field
m
Nope - I already tested. Suppose I have an already saved 
vendor prepayment
-- if I now go to the 
subsidiary
record and change the default account, then if I edit the 
vendor prepayment
I'm not able to change the account to the new 
subsidiary vendor prepayment account
-- it's a mistery
m
this is possible but will have to require the use of several scripts. Basically if I select an account in a custom list, another script would be called to update the subsidiary record and once this task is completed, another script reload the vendor prepayment page so that the account change is taken into account
l
@Marc I like that idea since we also want to post to different prepayment accounts. What if 2 or more different users create a Vendor Prepayment for the same subsidiary but with different prepayment accounts at almost the same time? Would that potentially cause an issue? Or is there a way to ensure only 1 user creates/edits a prepayment per subsidiary?
m
this will be difficult, as of the time of creation, you don't know which user will hit 
Save
first but again - all this is only possible at the time of creation - you cannot change the account afterwards
m
@Milcho Dimkov maybe a gl plugin could work reverses the original vendor prepayment account and debits the new account
I did a test with Suitelet Script: Display a form to select subsidiaries and VP accounts. The user selects a value and after submission, this triggers a Map/Reduce script and redirects the user to a new VP page with a 10-second delay (sorry, I don't have time to create another script to query the status of the MRS, it's just a test). Script MRS: Updates the subsidiary record according to the user selection in the Suitelet ( parameters) and changing the VP account. When the suitelet is redirected to the new VP, we can see that the VP account corresponds to what the user selected in the suitelet.
basically, this is just a simple test I did, but if I optimized it, it would work perfectly.
m
yes - this is a possibility indeed - thanks for spending some time on it : ) I think you can even do it directly with suitelet(s), without the M/R The main issue though remains: you can't change the account once the VP is saved. In our case, we want to be able to change it before approval. Thanks! : -)
m
in fact no need for the MRS for this example Maybe a gl'plugin could solve your issue
3 Views
Open in Slack
PreviousNext
Powered by