Make Currency To Print to Default to "Originating"

(0) Share

Report

Posted on by Community Member

Hello

When I open up a historical document (one that I've posted) on Sales Transaction Window, and click on the Print icon It opens Sales Document Print Options but Currency To Print drop down Defaults to "Functional" rather than Origination Which is what I'd like to have.

Now this only defaults to Functional when a historical document is opened, if am unposted record is opened and print option clicked, Currency to print is set to Originating.

could someone assist me to set this to default to Originating at al times.(or a VBA editor modification that might fix this)

Thanks

*This post is locked for comments

All responses (25)

Answers (3)

Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

from Customization Maintenance window, select your VBA and export the package and from same window import the package in the gp of other pcs.

Navigation: Tools>>Customize>>Customization Maintenance.
Verified answer

Community Member on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

Hi

I managed to fix this with an If statement,

Private Sub Window_AfterActivate()

If CurrencyToPrint.Enabled = True Then

CurrencyToPrint.Value = 2

End If

End Sub

But this works on my PC , but not on other PCs with GP. which is what I want

how do I deploy this to other users using different PCs??

Thanks
Community Member on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

No I haven't got any other VBA on this page.

This error pops up only when I don't select a sales document and click Print icon.

The reason I believe this happens is when Print icon is clicked without a sales doc opened up, it opens Sales Document Print Options window with no information filled up and all fields disabled. And because we have our VBA to run after window is Activated, it gives this error as it cant change the value to Originating for a field that's disabled.

If I open Sales Transaction window select a sales doc and click print it'll open up Sales Document Print Options window without fuss
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

If you will set currency option in main form, sales transaction entry window , that value will automatically will be set in this window, anyway even with setting currency option on that window is working, do you have other VBA codes?
Community Member on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

I added SalesDocumentPrintOptions in VBA because that's where this CurrencyToPrint field is in? which is what I want changed.
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

I can see you have added window SalesDocumentPrintOptions in VBA? May I know why you added code on that window instead of Sales Transaction Inquiry Zoom window?

For other users deployment: You don't need to do anything if all users use the same machine.

If there are several other machines create package file and import to other systems.
Suggested answer

Jothi Krishnan N 1,877 on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

If you have dont have Multicurrency Management marked in the Registration, these Originating/Functional fields, menu etc will be disabled/hidden and so you cannot change it through VBA code. So if these fields are disabled, check everything related to Multi currency setup/registration and you might have to run check links on those Multicurrency related tables as well. But ensure that you test these in TEST env first and also make sure you have taken a DB backup.

To make it available for everyone, just copy the Dynamics.vba file from the machine where you have the code and put it in the GP folder on other users' machine.
Community Member on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

and what else do I have to do to deploy this to all users, do you know?

Thanks
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

You must be doing something wrong, could you share screen shot of the VBA code, so I can check what exactly you are doing and where.
Community Member on at

Like (0)

Report

RE: Make Currency To Print to Default to "Originating"

One more thing,

Now, when I open Sales Transaction Window and click on the print button it brings up the Print options screen with a Run-time Error

it says that we've set a default value to a disabled field.

Is there a way to remove this ?