x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 133 subscribers
  • Views 739 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
755
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
851
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
182
topics
408
replies
surajit

How to Configure Sage300 2018 so that store Date and time for OEOrder and OEInvoice

Posted By

Hi Expert ,

    I am using Sage300 api . I want to filter  api with Order /Invoice Creation datetime . I am facing one issue in my response i can't see any time in creation datetime field .

Any one can help me how it can be possible that Date and Time both will be saved for Order / Shipment and Invoice.

Thanks

Surajit Kundu

Parents
  • 0

    <OrderDate>2020-06-30T00:00:00Z</OrderDate>
    <ExpectedShipDate>2020-06-30T00:00:00Z</ExpectedShipDate>
    <QuoteExpirationDate />
    <OrderFiscalYear>2019</OrderFiscalYear>
    <OrderFiscalPeriod>Num1</OrderFiscalPeriod>
    <ShipViaCode>CCT</ShipViaCode>
    <ShipViaCodeDescription>Cross-Country Trucking Lines</ShipViaCodeDescription>
    <LastInvoiceNumber>IN0000000000060</LastInvoiceNumber>
    <NumberOfInvoices>0</NumberOfInvoices>
    <FreeOnBoardPoint>Port of Vancouver, BC</FreeOnBoardPoint>
    <TemplateCode>ACTIVE</TemplateCode>
    <DefaultLocationCode>2</DefaultLocationCode>
    <OnHold>false</OnHold>
    <OrderDescription>Ship within 2 days</OrderDescription>
    <OrderComment></OrderComment>
    <OrderPrintStatus>None</OrderPrintStatus>
    <LastPostingDate>2020-06-30T00:00:00Z</LastPostingDate>
    <OrderNumberOfPrepayments>0</OrderNumberOfPrepayments>
    <OverCreditLimit>false</OverCreditLimit>
    <ApprovedLimit>-565.63</ApprovedLimit>
    <AuthorizingUserID></AuthorizingUserID>
    <RequiresShippingLabels>false</RequiresShippingLabels>
    <ShippingLabelsPrinted>false</ShippingLabelsPrinted>
    <OrderHomeCurrency>CAD</OrderHomeCurrency>
    <OrderRateType>SP</OrderRateType>
    <OrderSourceCurrency>USD</OrderSourceCurrency>
    <OrderRateDate>2020-03-18T00:00:00Z</OrderRateDate>

Reply
  • 0

    <OrderDate>2020-06-30T00:00:00Z</OrderDate>
    <ExpectedShipDate>2020-06-30T00:00:00Z</ExpectedShipDate>
    <QuoteExpirationDate />
    <OrderFiscalYear>2019</OrderFiscalYear>
    <OrderFiscalPeriod>Num1</OrderFiscalPeriod>
    <ShipViaCode>CCT</ShipViaCode>
    <ShipViaCodeDescription>Cross-Country Trucking Lines</ShipViaCodeDescription>
    <LastInvoiceNumber>IN0000000000060</LastInvoiceNumber>
    <NumberOfInvoices>0</NumberOfInvoices>
    <FreeOnBoardPoint>Port of Vancouver, BC</FreeOnBoardPoint>
    <TemplateCode>ACTIVE</TemplateCode>
    <DefaultLocationCode>2</DefaultLocationCode>
    <OnHold>false</OnHold>
    <OrderDescription>Ship within 2 days</OrderDescription>
    <OrderComment></OrderComment>
    <OrderPrintStatus>None</OrderPrintStatus>
    <LastPostingDate>2020-06-30T00:00:00Z</LastPostingDate>
    <OrderNumberOfPrepayments>0</OrderNumberOfPrepayments>
    <OverCreditLimit>false</OverCreditLimit>
    <ApprovedLimit>-565.63</ApprovedLimit>
    <AuthorizingUserID></AuthorizingUserID>
    <RequiresShippingLabels>false</RequiresShippingLabels>
    <ShippingLabelsPrinted>false</ShippingLabelsPrinted>
    <OrderHomeCurrency>CAD</OrderHomeCurrency>
    <OrderRateType>SP</OrderRateType>
    <OrderSourceCurrency>USD</OrderSourceCurrency>
    <OrderRateDate>2020-03-18T00:00:00Z</OrderRateDate>

Children
No Data

*Community Hub is the new name for Sage City