Interview Questions.

Q1. When Are Vouchers Items And When Are They Tenders?

Vouchers are objects while they're bought to a patron. Vouchers are tenders whilst they may be redeemed by way of a patron for merchandise.

Q2. Should The V_total_totalname Table Be Used Instead For Sa_sys_value (for Calculated Totals) For Getting The Most Recent Value For A Totals On A Store/day?

No, V_SA_TOTAL_VALUE view ought to be used to get the modern day Total Value.

Q3. On The System Option Form, In Retail Sales Audit (resa), There Are Two Fields In The Compare Store Criteria Block, Date To Determine Comp. Store Status And No. Elapsed Days To Determine Comp. Status.

These are used for the Flash Sales reports – permitting the business to determine whilst a store has enough trading history. The date to decide comp. Status can be primarily based on three elements: save open date, remodel date, or acquire date. These dates are hung on the shop table inside the Retail Merchandising System (RMS).

Q4. What Is The Difference Between A Total And An Audit Rule In Retail Sales Audit (resa)?

Totals in ReSA can both come from the Point of Sale (POS) or different outside structures through the Retail Traction Log (RTLOG). ReSA also can calculate the overall itself based totally on uncooked traction statistics or current totals. Totals are utilized in acting shop balancing (over/quick), evaluation within ReSA and exporting to present tractions in addition to totals. If a rule fails, the gadget generates an exception i.E; the retailer defines if the mistake may be overridden as well as what structures the mistake affects. This gadget impact prevents a bottleneck within the export method through handiest prohibiting the export of the traction or overall to the systems defined within the device effect. Even if the traction or overall is in mistakes, ReSA will nonetheless export it to different structures as long as they may be no longer defined within the gadget effect for the given mistakes.

Q5. How To Find Out What Roles A User Have, And If Those Roles Have The Correct Privileges?

To verify whether a user turned into granted a privilege, or a function changed into granted a privilege, you may use the subsequent (for this situation, RMSDEV101A is used): 

Check to see if the consumer became granted the gadget privilege without delay: 

SQL> desc dba_sys_privs 

SQL> pick out * from dba_sys_privs where grantee = 'RMSDEV101A';

If the end result for the above query does not display the system privileges granted for the consumer, check to look what roles the consumer turned into granted, and then check to look what privs has been granted to that position:

SQL> desc dba_role_privs 

SQL> select * from dba_sys_privs wherein grantee = 'DEVELOPER'; 

Whenever you need to see what roles and device privileges a user has and what system privileges are assigned to specific roles, you should study the dba_role_privs and dba_sys_privs perspectives. 

From a ReSA perspective a user have to have the subsequent privileges to create totals and views: 

Create any view 

Create any procedure 

Alter any manner 

Drop any view 

Drop any system

Q6. Is There A Complete Standard Output Of Data For Archiving Data In Resa?

Tractions may be exported to Retail Data Warehouse (RDW) for reporting. Tractions can be stored online in ReSA for contemporary usage or purged while they're now not wished.

Q7. Is The Currency-based totally Rounding Rules Only Used For Resa?

No, Price Rounding additionally makes use of Currency-based totally rules.

Within the System Options dialogue there's a field called 'Pricing Rules for New Items'. This is represented within the database as SYSTEM. OPTIONS.PRICING.RULE. This field determines which pricing regulations ought to be used while creating objects and charge modifications, promotions, and clearances inside Retail Merchandising System (RMS). Valid values for this field are 'R' for Rounding Rules or 'P' for Price Point. A value of 'R' shows that the rounding guidelines, special by way of the consumer, can be used whilst creating an item. If the consumer chooses the pricing factor guidelines, then the price factor guidelines can be applied.

When creating a fee trade, merchandising or clearance we will determine how the fee "will appearance", via deciding on one of the following Adjustment Types:

EI - Ends In

PP - Price Point

RO - Round

NO - None

If Round (RO) is selected, RMS will check for the existence of rounding policies for the forex or forex and country. If they exist, they will govern the rounding. If they do not, regular arithmetic rounding may be implemented. If Round is the Adjustment Type chosen, RMS will use rounding rules based totally at the forex chosen in System Options supplied that 'R'ounding is the price for the System_Options.Pricing_rule. 

If Price Point (PP) is the Adjustment Type selected, and SYSTEM_OPTIONS.PRICING_RULE is identical to Price Point, the Price Point policies as setup by the person will practice. These regulations are defined within RMS and saved on the database degree. 

Default RMS rounding capability dictates that when applying a price change in the clearance, merchandising or fee exchange paperwork, or during object setup, outcomes inside the rate being rounded with  implied decimals (e.G. Unique fee is 349, and with 10% off that is rounded to 314,10). Currently, RMS does now not accommodate person described rounding rules. Therefore, the default rounding functionality is used. However, with the improved use of overseas forex, there are numerous exceptional rounding rules that may be used as an alternative.

Changes inside RMS and ReSA had been made to put into effect overseas 

Q8. What Exactly Does The Saimptlogfin.Laptop Batch Program Do In Retail Sales Audit (resa)?

Saimptlogfin.Laptop creates a stability organization access (SA_BALANCE_GROUP table) for the store/day, cancels put up voided tractions, updates the Data Status to ‘Fully Loaded’ if the ‘DCLOSE’ traction is acquired (sets Store Status to ‘Closed’ if single level audit). It also removes missing traction information which are now gift because of loading data out of collection.

Q9. How Can The Count Or Number Of Tractions For A Specific Traction Type (e.G. Sale) Be Viewed In Resa

The be counted or wide variety of tractions isn't contained inside the overall of income or returns. This statistics can be utilized within the Store Operations Workbench of the Retail Data Warehouse (RDW).

Q10. Why Is The 'traction Find' Window Through 'traction Maintenance' Menu Not Restricted To The Users Home Store While The Store / Close Audit Screen Is?

The Traction Find Window thru Traction protection menu is used to create new or view, edit tractions or create put up void. While the store / near audit display screen is used to audit days tractions.

Thus typically the store / near audit display screen by default fetches shop/day for the person's home shop. But as I described in advance, if the person has get right of entry to to different stores also, he or she will get entry to tractions for those shops as well.

Since the Traction Find Window through Traction Maintenance menu is used to create new or view, edit tractions or create put up void, it does not routinely defaults to the user's home shop.

But this restrict to the users home keep may be completed on both the monitors if the consumer is restricted to his home save thru RMS security option.

Q11. Is It Possible To Restrict The Ability To View All Stores By Location Security In Rms? Is It The Same Restriction For The 'traction Find' Window Through 'traction Maintenance' Menu ?

Yes, if one consumer is given confined get right of entry to to best his or her domestic shop thru RMS place safety, he can be capable of get entry to his home shop and nothing else. The identical limit holds for the Traction Find Window via Traction

protection menu. That is, if one consumer is given restricted get admission to to best his or her home save thru RMS area safety, he will be capable of get admission to his home keep and nothing else on this display also

Q12. How Are The Escheatment Rules Determined In Resa? Are They Determined By The State Where The Voucher Was Sold Or The State Where The Recipient Of The Voucher Resides?

The Escheatment capability in ReSA is pushed by the hierarchy of Store, Issuer, Recipient, & HQ. When acting escheatment, ReSA assessments if there's an cope with for the first level of the hierarchy, the Store. If so, it exams if the kingdom or us of a is described within the Escheatment table in ReSA. If the nation or us of a exists at the table it then exams to see if the Store indicator for that nation or u . S . Is ready to yes. If so, ReSA escheats these monies to that country or us of a. If no kingdom or country exists for the store, or one does but does no longer exist at the Escheatment desk, or it does exist on the desk but the Store indicator is ready to no, then ReSA checks the following degree, Issuer, and so forth. If no fits are determined after ReSA exams all four tiers of the hierarchy, then the store claims the voucher as earnings. 

If claimed as sales, this is a non-merchandise type of bill. 

An access inside the companion desk (escheatment authority be described to signify to whom the monies might be sent. 

If a voucher is redeemed after it's been escheated, it is the responsibility of the store to acquire those monies from the authorities 

Only the extremely good voucher quantity is escheated.

Q13. What Are The Possible Roll_up Levels For The Total Defined On Register Level And Store Level Totals?

In the Total Definition wizard > Roll Ups display screen

The Roll Ups display screen permits the consumer to outline the parameter so one can genuinely count (or summed). It also permits the person to outline up to 3 parameters to group by. Only parameters that have formerly been delivered to the whole definition may be both counted (summed) or grouped by means of.

If the overall is at the shop stage, that means the person best desires one fee consistent with save, the gadget automatically assumes a roll up to the store/day stage. If the full turned into described to be on the cashier/check in balancing stage, and the user wanted one overall cost in line with cashier/sign up, the device might expect a roll as much as cashier/sign in.

Q14. How Can User Know Whether It Is A Single Or Multilevel Audit Scenario? Is There Any Indicator Or Value Exist For This?

This statistics is maintained at the Store Data window of the Store Maintenance shape within the Retail Merchandising System (RMS). The multi-stage audit settings for person stores are stored at the ds_store_data desk. Stores are described as multi-degree audit stores when the system_code discipline is ‘MLA’and the imp_exp subject is ‘I’ for a specific store. If those settings aren't defined for a store, then ReSA defines the shop as a unmarried degree audit keep. Single level audit could be described if the user chooses ‘Point Of Sale (POS)’ as an import for a given store. 

Q15. What Are The Definitions Of The Different Store Status Options On The Store Day Find Form In Retail Sales Audit (resa)? What Triggers A Store Status To Change To Close? At What Store Status Can The St

Worksheet – When a shop is defined as a multi-degree audit keep (each shop personnel and HQ auditors will use ReSA), the store is loaded into ReSA in a Worksheet reputation. The keep/day can be deleted on this reputation. 

Fuel Closed – This repute is simplest used for fuel shops as a way to be exporting to Oracle Site Fuels Management (SFM). Stores are loaded into ReSA in a Worksheet fame; but, the audit can't begin till the day is closed in SFM first. When that is performed, ReSA updates the fame to Fuel Closed. The keep/day can be deleted in this reputation. 

NOTE: SFM will send again a report signifying that the shop tractions had been processed and reconciled. This will symbolize Fuel Closed – and enable the facts to be labored on in ReSA. 

Closed – In a multi-degree audit state of affairs, the store employee ought to close the shop day once all errors have been corrected or overridden. This updates the shop reputation to Closed and makes the shop/day to be had to the HQ auditor. In a single degree audit situation where handiest HQ auditors are the usage of ReSA, the store is loaded into ReSA in a Closed status. The save/day can't be deleted on this fame

Q16. If The 'save Close Audit' Menu Shows The Users Home Store Automatically, Then Why Is It Not Visible In The 'traction Find' Screen?

While growing an employee through Employee Maintenance Screen, you can assign multiple shops to the worker.

But best one store can be selected as the Home Store of that worker. When this employee is going into Store Day Find display screen through 'Store Close Audit' menu, Retail Sales Audit (ReSA) mechanically queries the store/days the user ought to audit based on their employee kind (save or headquarters) and assigned stores.

If a store employee is assigned a home shop, the Store Day Find window initially displays only information for that given shop.

The consumer can refresh the display screen and pick distinctive criteria to view information for either all assigned stores or all shops.

(The ability to view all shops is restricted by way of region safety in Retail Merchandising System (RMS).)

The consumer can use Store Day Summary window to view tractions from a single shop and day. This way the Traction Find window works for a single store. But the user needs to go to the display screen via 'Store Close Audit' menu.

So, the Traction Find Window thru Traction upkeep menu isn't always constrained to the users home keep. It is used to search for tractions throughout a couple of shops and/or days.

Q17. How To Populate "sa_export_options" Using Resa User Interface (ui) ?

Sa_system_options isn't always up to date from RESA UI but is populated at time of installation by means of running the script sa_system_required.Sq. 

Q18. Why Does Resa Send Bank Deposit Estimates To The Ach?

ReSA is estimating the following day’s financial institution deposit and sending this amount to the consolidating financial institution through the ACH network. This is used to hedge the cash that is to be acquired from the shops. 

If the retailer does now not perform this characteristic, they do no longer need to run the batch software (saexpach.Pc). There is no effect to ReSA if this isn't always run.

Q19. On The Bottom Of Page three Of The Totals Calculation Definition Wizard In Retail Sales Audit (resa), There Is A List Box For Display Group And A Display Group Details Button. What Tables Hold This Inform

The Display Group listing field defines in what order the overall can be displayed at the described shape in ReSA. This data is held on the sa_total_head desk within the display_order field.

The Display Group Details button shows all other totals which can be described to be displayed at the same shape, total class and percentage the equal display group placing for the given overall. If a couple of total has the identical show order, then they will be displayed alphabetically. This information isn't held on one particular discipline, however as an alternative queries more than one fields at the sa_total_head desk.

Q20. How Is Traction Level Discount (i.E. Slab Discount) Handled In Rtlog File In Retail Sales Audit (resa)?

If you have got a scenario at Point Of Sale (POS) in which in you give a discount of one hundred at a Total Bill of 10@This discount does not follow to any object however is at a Bill degree.

Retail Merchandising System (RMS) does not helps bill/traction stage reductions, RTLOG document will no longer have a traction-level cut price (TDISC) report, so POS device need to be despatched item-degree bargain. But that doesn't suggest ReSA handiest handles item-degree discounts (IDISC). The slab discounts or invoice/traction stage reductions are in truth apportioned among all of the gadgets in that invoice in percentage to their fees & gadgets bought.

If you have a scenario at POS where in you give a discount of one hundred at a Total Bill of 10@And it has  objects priced otherwise then the traction-degree bargain can be divided among those two items according to their person charge & bought devices :-

Item Price Quantity Discount

Item A four hundred 1 forty

Item B a hundred 6 60

Also for Slab discounts, there may be a chit or a pamphlet to explain this discount based on slabs.

If there is a voucher or coupon concerned then the Traction data ought to have an extra TTEND file to denote the reductions received by using those coupons or vouchers for a specific traction.

Q21. How Does A Retailer Turn This Functionality Off If They Do Not Practice Escheatment?

If a store does now not need to use the escheatment capability they will now not check the Escheatment indicator at the System Options form. Since the store will no longer be escheating those monies to governing government, the retailer will claim those monies as income; consequently, they must outline while these extremely good vouchers may be claimed as profits at the Voucher Options window at the System Options shape. The store still need to run the saescheat.Laptop program on the way to declare these vouchers as profits.

Q22. What Is Automated Clearing House (ach)?

ACH is a United States based banking community used to electronically trfer price range. The National Automated Clearing House Association (NACHA) regulates this community and keeps the requirements.

Q23. Is The Gl Amount Equal To The Basic Level Amount Or Rolled Up Level Amount Or Some Other Amount?

According to RMS Data Model, the table SA_FIF_GL_CROSS_REF is used to companion an Oracle account code with the one of a kind styles of totals that can be calculated through Sales Audit. Different account codes can be associated with the equal general type at extraordinary locations and different degrees of rollup. And additionally the 3 roll u.S.A.In this desk are similar to rollup tiers of general. 

There is one extra table FIF_GL_ACCT , which holds all the account related data, that allows you to be bridged throughout from the respective Financial Application.

Q24. What Is The Store Ach Maintenance Form Used For In Resa?

This form is used to view the ACH information (Manual Deposit Adjustment, Estimated Deposit, Estimated Deposit Adjustment) for a particular shop. 

The store can also make a Manual Deposit Adjustment to tomorrow’s ACH Amount if they feel the actual deposit can be distinctive than the estimated deposit for the next day. The Add button is used to permit the follow block to enter a Manual Deposit Adjustment for a shop/day (e.G. Christmas time when the predicted income are extra than the common for the final 4 weeks). This Manual Deposit Adjustment ought to be made previous to the execution of the ACH application. 

The sum of the Manual Deposit Adjustment, Estimated Deposit and Estimated Deposit Adjustment produces the ACH Amount for the store/day. This is the amount so that it will be despatched via the ACH network to the consolidating bank.

Q25. What Is The Ach Estimation Formula?

The ACH application estimates the following day’s bank deposit by way of averaging the preceding 4 actual financial institution deposits for that given day of the week (e.G. The estimate for Monday will take the common of the actual bank deposit from the previous 4 Mondays). If the gadget most effective has three weeks of records, it's going to use the common of the previous 3 Mondays. If simplest two weeks of data exists, it's going to use the common of the preceding two Monday. If simplest one week facts exists, it's going to use the financial institution deposit from the previous Monday. If much less than one week of facts exists, it'll use yesterday’s deposit and if no statistics exists, no estimate will be created. 

The system additionally compares the previous day’s estimate for nowadays’s bank deposit towards these days’s actual financial institution deposit. It will upload the difference to the common for tomorrow to create an Estimated Deposit Adjustment if vital.

Q26. Does Only Point Of Sale (pos) Data Come Through Retail Sales Audit (resa)?

Stock Counts, Receipts, Trfers and Inventory Adjustments aren't despatched through ReSA. These styles of tractions can both be supported by means of Retail Store Systems (RSS) or loaded directly into the Retail Merchandise System (RMS) from the POS. Trfer Ins, Trfer Outs, Receipts, and Return to Vendor (RTVs) can be loaded without delay into RMS the usage of upload files. 

Main tractions processed with the aid of ReSA are the subsequent:

Sales

Returns

Exchanges

Voids

Post Voids

Paid In / Paid Out

No Sales

Pull

Loan

Open

Close

Fuel Tractions (e.G. Tank Dips, Meter Readings, etc…) 

NOTE: Not all POS structures guide all of these tractions.

Q27. What Is The Difference Between Accountable For And Accounted For Totals On The Over/brief Form In Retail Sales Audit (resa)?

Accounted For:These totals constitute what's bodily counted in the till. (e.G. Total cash on hand, total assessments, and so forth…). These totals are anticipated from the Point of Sale (POS) or some other external system. 

Accountable For:These totals constitute what should be within the until (e.G. Sales, Returns, etc...). These totals can both come from the POS or ReSA can calculate these totals.

Q28. Can Sales And Returns Occur On The Same Traction Record In Retail Sales Audit (resa)?

Yes, ReSA identifies a standing on the item stage (item_status subject on the SA_TRAN_ITEM desk). 

The three statuses are Sale, Return and Void. A Sale or Return traction can comprise any kind of objects with one-of-a-kind statuses; but, ReSA identifies a Sale traction as net money being paid into the until and a Return traction as net money being paid out of the until. ReSA identifies an Exchange traction when no cash modifications palms.

NOTE: The traction type is held in SA_TRAN_HEAD while the person traction kind is recorded in the SA_TRAN_ITEM table.

Q29. What Is The Difference Between V_sa_tran_item_net_rolled And V_sa_tran_item_net And When Would Each Be Applicable?

The V_SA_TRAN_ITEM_NET_ROLLED offers the Retail price of 1 Item after all the Discounts applied to it. 

If one Item is having  reductions, the V_SA_TRAN_ITEM_NET_ROLLED view will display a single line for that object.

Also V_SA_TRAN_ITEM_NET_ROLLED could have the overall bargain implemented to it. 

On the other hand V_SA_TRAN_ITEM_NET will display two different lines every for one bargain.

Q30. In Currency Rounding Rules Detail Maintenance(sarruldt) Form, When Defining The First Range As zero To 0.2600, Why Is It Not Possible To Use zero.2700 As The Lowest Ending Amount For The Next Range?

After applying some computations, the resulting amount may also come up as having four decimals. If rules with handiest 2 decimals are described, then the four decimals won't be included by any of the rules. That is, Rule zero - zero.24 rounds to zero; 0.25 - 0.Seventy four rounds

to 0.50 and zero.Seventy five - 1 rounds to @Given 24.2455, the decimals zero.2455 does no longer belong within any of the described variety. The number of decimals for the Round Amount might be based totally on CURRENCIES.CURRENCY_RTL_DEC. For a currency described as having 2 decimals, then it'll be rounded to two decimals. Therefore, inside the SCARLET.FMB, the LOW_ENDING_AMT and HIGH_ENDING_AMT (for the variety) should be entered as four decimals.

The foreign money rounding rule range can not overlap. Thus whilst the first range is 0 - 0.2700; the next range need to start with zero.27@If the primary variety is defined as 0 - zero.2659; the next range will start at 0.2660

Q31. What Happens In Resa If The Cost Method Of Accounting Is Used?

The value of sales isn't utilized in ReSA - only sales is captured. 

Cost of sales facts will nevertheless be determined in the Retail Merchandising System (RMS), not in ReSA.

Q32. What Is Significance Of "domestic Store" Indicator In Resa? Explain In Detail?

If a store employee is assigned a home keep inside the Employee Maintenance shape, the Store Day Find shape will show handiest facts for that given shop while Edit/View is chosen from the motion container. To view all the stores assigned to the consumer in ReSA (the Employee Maintenance shape), click the refresh button and choose the Assigned Stores radio button. 

Q33. There Are Five Totals Displayed On Miscellaneous Totals Window (samisctl). What Do They Signify?

The Miscellaneous Totals window permits you to go into and preserve the totals inside the machine for a specific Store Day. This window allows you to go into your model of the full. This window carries a listing of the Total Categories and a corresponding listing of the totals which are contained in a selected Total Category.

Following is the listing of totals displayed at the display screen:

POS Reported: This shows the fee imported from an outside system including POS.

System Calculated: This shows the fee calculated by way of Oracle Retail Sales Audit (ReSA) based on raw traction information or existing totals.

Store Reported: This displays the cost up to date via a Store Employee of either the POS said or System Calculated price.

HQ Reported: This shows the cost up to date by a Headquarter auditor of either the POS mentioned, System Calculated or Store Reported fee.

Last Reported: This is the price that is taken from one of the 4 totals in that order- HQ Reported, Store Reported, System Calculated or POS Reported which isn't NULL. If all of the four totals are NULL, then Last Reported can be NULL.

Q34. If The Retailer Does Not Perform Escheatment, Can The Saescheat.Computer Program In Resa Be Used To Claim These Outstanding Vouchers As Income?

Yes, the SAESCHEAT.Computer application will guide this characteristic. If the store does not carry out escheatment, they should no longer check the Escheatment Indicator on the System Options shape. If this indicator isn't always set, the Escheatment button is disabled; but, the Vouch. Opt. Button remains enabled. The retailer might click this button to open the Voucher Options window. In this window, the store will outline within the first column whilst the voucher will be claimed as profits (the range of days after issuance). In the second column, the store will outline while the voucher can be purged from ReSA (the range of days after claiming the voucher as profits). The retailer will define this standards for each Tender Type ID assigned to the Tender Type Group of ‘Voucher’.

Q35. On The Escheatment Window Located On The System Options Form, In Resa, There Are Four Indicators (problem, Recipient, Store And Hq). What Is The Purpose Of Selecting These Indicators, Especially Since A

In america, each state has distinctive escheatment guidelines. We have created a level of hierarchy in ReSA for escheatment regulations (Store, Issuer, Recipient and HQ). When defining each escheatable kingdom or u . S . A ., the store will suggest how many tiers of the hierarchy may be checked. 

The voucher must be past the escheatable variety of days (SA_VOUCHER_OPTIONS.ESCHEAT_NO_DAYS). The software will take a look at if a kingdom or united states of america exists for the first stage of the hierarchy, the Store. If so, it's going to test if this kingdom or united states is described in the Escheatment Options and whether or no longer the Store indicator is set for that associate. If a match is found, ReSA will escheat the voucher quantity to the kingdom or us of a of the Store. 

If no fit is determined at the shop degree, this system will carry out the same exams as mentioned above thru the entire escheatment hierarchy till a healthy is discovered. If no match is discovered, the retailer will declare the voucher as earnings.

Q36. What Is Escheatment?

Escheatment is the technique of forwarding monies of first rate, non-expiring vouchers to the proper governing authorities after a defined time frame from the date of issuance.

Q37. Does The Retail Merchandising System (rms) Batch Program Posupld.Computer Still Perform The Same Validation Routines If Resa Is Installed?

If ReSA is on (machine alternatives.Sales_audit_ind set to ‘Y’), a few statistics is taken from the ReSA file instead that being seemed up; however, pretty a piece of validation remains carried out. Value Added Tax (VAT) and currency information isn't proven (on shop and currencies). Merchandise hierarchy isn't always tested.

Q38. How Does Retail Sales Audit (resa) Know That A Store Will Be Trickle Polled?

There is not any setting in ReSA to define if a shop could be trickle polled. The only requirement is to send a ‘DCLOSE’ traction to ReSA on the give up of the day. If a Retail Traction Log (RTLOG) is loaded however does not include the ‘DCLOSE’ traction, the Data Status is up to date to ‘Partially Loaded’. If the ‘DCLOSE’ traction is acquired the Data Status is updated to ‘Fully Loaded’.

Q39. What Condition Should Exist For Store Based On Which Saexpgl Batch Picks Up The Data To "stg_fif_gl_data" Table?

SAEXPGL exports totals to Oracle Financial Application trendy ledger for: 

Sales tractions 

Tenders 

Paid-ins 

Paid-outs 

Taxes 

This export batch module works by way of first getting the store day. Then it reveals the totals to export and verifies that person totals contain no mistakes for both the store/day (if keep/day is the unit-of-work described by way of the user) or keep/day/general (if save/day/total is the unit-of-work described by means of the user). Next the module appears at the SA_FIF_ORA_CROSS_REF table to determine which Oracle account ID (Cost Center ID) it needs to export to. Determine if the chosen shop/day/general has been previously exported; if so, opposite the preceding posting, and submit the ultra-modern adjustments to the General Ledger (GL) staging desk. Finally it movements the statistics to the Oracle staging GL_INTERFACE. (No RMS staging desk is worried.)

Q40. Does The Sa Escheat.Computer Batch Program In Resa Create A File Or Does It Insert Into The Retail Invoice Matching (reim) Tables? If This Populates The Tables, What Will Happen If The Retailer Does Not Hav

SA  ESCHEAT.Pc simplest creates a complete and writes this to the SA_ESCHEAT_TOTAL table. The SAEXPIM.Pc program reads from this desk. This program is owned by using ReIM.

If the store does no longer have ReIM, then a custom interface could want to be written to examine the SA_ESCHEAT_TOTAL desk to export the data into the store’s appropriate software

Q41. When Using The Delete Store Day Functionality, Will The Store/day Record Be Deleted Or Just The Tractions For That Store/day?

When deleting a Store/Day, it's miles absolutely the traction records for the store/day which can be deleted as opposed to the shop/day file. SA_TRAN_HEAD.STATUS can be set to 'D' and those tractions will no longer be accessible thru the Traction Maintenance display screen.

Q42. Does Resa Accept And Process Dsd (direct To Store Delivery) Tractions?

ReSA handiest helps the DSD situation while a price is made by way of the shop to the vendor. ReSA requires that those bills be entered within the Point of Sale (POS) or other Retail Traction Log (RTLOG) like minded systems as ‘Paid Out’ tractions.

Included in this Paid Out traction are the subsequent records:

Amount paid

Vendor ID

Invoice Number

Proof of Delivery Number

This facts is loaded into ReSA and exported to Retail Invoice Matching (ReIM).

The store is also required to create an access for the DSD inside the Retail Merchandising System (RMS) using the Quick Order Entry display. On this screen they will input the vendor, bill variety or proof of transport range, and suggest if the vendor save. RMS will export this traction to ReIM as well. ReIM will healthy this RMS traction with the ReSA traction to affirm a payment changed into made. This invoice will then be exported to the retailer’s AP financial device with a ‘Paid’ indicator.

NOTE: ReSA does not manage the actual receiving of the stock. This has to be finished the usage of either RMS interfaces or Retail Store Systems (RSS).

Q43. Why Post Voided Tractions From Resa Forms Are Not Picked By Saexprms?

When doing a Post Void on a traction from ReSA paperwork and strolling SAEXPRMS batch, the traction will best be picked up if it's miles already exported. But if it's miles submit voided earlier than export, it basically me it's far canceled and no data need to be sent to RMS for this traction.

Q44. Is The Sapurge.Computer Program Of Resa Multi-threaded And Restart/recoverable?

Yes, it is multi-threaded and restart/recoverable.

Q45. What Is The Difference Between A Table Driven Audit And A Sub Program Driven Audit In Retail Sales Audit (resa)?

Table driven audits are created the usage of the Rules Calculation Definition Wizard in ReSA while sub program pushed audits are difficult coded audits such as the validations covered in saimptlog.Pc (e.G. Card quantity validation).

Q46. Why Is A Sales Audit Table (prefixed With Sa_) Used In Standard Rms (oracle Retail Merchandising System) Functionality As Currency Rounding In Price Management?

The Currency Rounding functionality turned into developed for ReSA and become extended to Pricing. Thus whilst it turned into decided to apply this capability to Pricing, we already have the ReSA rounding guidelines desk.

Q47. What Is The Meaning Of Fields Roll_up_level 1 , Roll_up_level 2 And Roll_up_level three In Resa Glcross Reference Screen 'saglcros.Fmb'?

Total - Roll Ups :

Roll-u.S.A.Permit a complete to supply a couple of values, it is equal to the part of the GROUP BY clause inside the SQL SELECT announcement that combines any rows that would have duplicate values inside the grouped by way of area

For example :

SELECT matter/sum(Value to be Totaled)

FROM realms

WHERE restrictions + joins

GROUP BY roll ups

Q48. Does Retail Sales Audit (resa) Have Its Own Sku/upc Tables That Are Populated By Sagetref.Laptop?

ReSA does not have its personal SKU/UPC tables. Sagetref.Computer creates a number of output documents from exclusive RMS tables together with ITEM_MASTER, VAR_UPC_EAN and so forth and the saimptlog.Pc batch application reads the documents to carry out area level validation. Some examples of those output files are a list of all legitimate SKUs, UPCs, promotions, codes, tenders, and so forth…

Q49. What Is The Purpose Of The Item Summary And Tender Summary Forms In Resa?

The Item Summary shape serves 3 purposes:

It is used to look for all of the tractions in which the unique item exists for a given keep/day.

The u specific traction and think about the details on the Traction Detail shape.

It is used to perform a mass object alternate for a selected item variety to some other legitimate object wide variety for a given keep/day.

If ReSA generates an invalid item wide variety error, the retailer can create the precise item within the Retail Merchandising System (RMS) and use this shape to re-validate the item wide variety. Since the object now exists in RMS, ReSA will do away with all invalid item quantity mistakes for the selected object for the given keep/day. 

The Tender Summary form is used to search for all the tractions wherein a specific smooth type organization become used for a given save/day.

Q50. What Triggers The System To Know Resa Can Start Exporting?

No special occasion in ReSA triggers the gadget to begin exporting, as an alternative the retailer defines while the export packages will run inside the batch time table. When those applications run (i.E. Saexprms.Laptop, saexprdw.Laptop, saexpgl.Laptop, and so forth…), they take a look at errors impacting that export exist for a store day. If no longer, then the statistics might be exported. The Retail Merchandising System (RMS) is the simplest device that ReSA will export a few ‘smooth’ tractions even supposing mistakes impacting RMS exist in other tractions. This is dependent on the Unit of Work placing in the System Options for ReSA. When set to Store, all RMS mistakes need to be corrected or overridden for a store/day earlier than any facts is exported. When set to Traction, only clean tractions are exported to RMS even if other RMS mistakes are remarkable. In later releases of ReSA 10.1.X, it is able to now export some ‘clean’ tractions to RDW (Retail Data Warehouse) just like how it is doing it for RMS.